My weekly tip OPTIMIZER_INDEX_COST_ADJ
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 29 Mar 2004 12:27:44 -0400
Hi,
After reading a lot from
OPTIMIZER_INDEX_COST_ADJ and
OPTIMIZER_INDEX_CACHING
The conclusion seems to be.
Even when the default values are horrible ,
1)you can work with the default values without problem.
2)Or you can tune them, and test by distinct loads you have.
Independently the choice you take, you must test them, before using in
production database.
:)
Personally I found I had to set them, but several other serious dba's says
default values are ok .
Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » My weekly tip OPTIMIZER_INDEX_COST_ADJ
