Re: Oracle does not use an index

From: "sybrandb@xxxxxxxxx" <sybrandb@xxxxxxxxx>
Date: 4 Nov 2005 01:06:04 -0800

The default value of these parameters are woefully inadequate.
The setting for the second parameter assumes indexes are never present
in cache.
This is simply not true.
My defaults are 40 for cost_adj and 90 for caching.

--
Sybrand Bakker
Senior Oracle DBA

.

Follow-Ups:
- Re: Oracle does not use an index
  - From: Niall Litchfield

References:
- Oracle does not use an index
  - From: schonlinner

Prev by Date: Re: Oracle does not use an index
Next by Date: Re: what is the difference between th DBMS and RDBMS?
Previous by thread: Re: Oracle does not use an index
Next by thread: Re: Oracle does not use an index
Index(es):
- Date
- Thread

Relevant Pages

Re: want to get the pointer of any python object in C++, but I Failed.
... The second parameter is "0" in the python' ... documentation. ... Prev by Date: ...
(comp.lang.python)
Re: want to get the pointer of any python object in C++, but I Failed.
... The second parameter is "0" in the python' ... documentation. ... Prev by Date: ...
(comp.lang.python)
RE: Streamwriter not creating file -- sometimes
... That parameter you have set to true, which is "Append" to existing file. ... then the second parameter needs to be TRUE otherwise set it for FALSE! ... Prev by Date: ...
(microsoft.public.dotnet.languages.vb)
Pass Parameter to Javascript
... I have javascript that accepts 2 parameters like so... ... function showmsgbox(chkB, somestring) ... I need to pass the second parameter o the function from within a datagrid ... Prev by Date: ...
(microsoft.public.dotnet.framework.aspnet)