My weekly tip OPTIMIZER_INDEX_COST_ADJ

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Mon, 29 Mar 2004 12:27:44 -0400
Message-ID: <004801c415aa$c78592e0$2501a8c0@dazasoftware.com>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon Mar 29 2004 - 10:28:21 CST