Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle does not use an index

Re: Oracle does not use an index

From: <sybrandb_at_yahoo.com>
Date: 4 Nov 2005 01:06:04 -0800
Message-ID: <1131095164.454428.95650@o13g2000cwo.googlegroups.com> 





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


Received on Fri Nov 04 2005 - 03:06:04 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US