Hi Michael!!!
This is the result of the query:
SQL> select value from v$parameter where
name like 'optimizer%'
or name =
'timed_statistics';
Results:
TRUE
9.2.0
CHOOSE
2000
100
0
1
7 rows
selected.
About your travel
plans:
Te recomiendo en otra
ocacion planear vacaciones a Guanajuato, o a la ciudad de Mexico son lugares en
donde hay mucho que ver. Sobre Cabo San Lucas mis hermanas estuvieron hay, y
dicen que es un lugar muy tranquilo y bonito.
Saludos!!!
>>> [EMAIL PROTECTED] 06/26/03 03:09PM >>> Teresita,
Usted tiene un nombre hermoso. Yo nunca he estado a Guadalajara, pero oigo es
muy agradable. La mayor parte de mi tiempo en México ha sido de Tiajuana
completamente al sur a Zijuantinajo. El País hermoso y muy entibiar a gente
Italia mucho más apreciando. Mi próximo viaje a México estará a Cabo San Lucas
probablemente en agosto. Espero llegar a Guadalajara algún día.
As for your current problem
with the index......
First run a script called
utlxplan.sql (spelling) from the $ORACLE_HOME/rdbms/admin directory under
the schema you wish to execute this query out of then
The optimizer_mode =
Choose , timed_statistics = true parameters
can be set in your
init*.ora file, but your can see the current setting of
these values through ...
SQL> select value from v$parameter where
name like 'optimizer%'
or
name = 'timed_statistics';
The query will also
return several optimizer values which may be needed for assessment
later
on.
If you cannot bounce (
restart) the instance then consider setting these parameters using the command
...
SQL> Alter
session set .....
Then
....
SQL> set
autotrace traceonly
also
consider
SQL> set timing
on
for a relative cost on
how much time the query takes
and then
Execute
your SQL statement which will output an explain plan for your
viewing pleasure.
Lots of information on
metalink on how to use and interpret the explain
plan.
Lets stop here and
report back what your output is on the explain
plan.
CAUTION: I
never use 3rd party products. I like to go straight to the data
dictionary to find out whats going on with the database. Not
to say 3rd party products are bad or anything, its just my style thats
all.
Espero que esto lo ayude
fuera.
Miquel.
|
- Re: Index question Tanel Poder
- Re: Index question Teresita Castro
- Re: Index question Mark Richard
- Re: Index question Teresita Castro
- RE: Index question Johnson, Michael
- RE: Index question DENNIS WILLIAMS
- RE: Index question Teresita Castro
- Re: RE: Index question rgaffuri
- RE: Index question Johnson, Michael
- RE: Index question Gabriel Aragon
- RE: Index question Teresita Castro
- RE: Index question Teresita Castro
- RE: Index question Teresita Castro
- RE: Index question Johnson, Michael