RE: how to evaluate optimizer_index

From: Polarski, Bernard <Bernard.Polarski_at_atosorigin.com>
Date: Mon, 22 Jan 2007 13:05:05 +0100
Message-ID: <25D4919915CCF742A88EE3366D6D913D11771E77@mailserver1>

The question is : how do I known when I need to alter the default values.

Bernard Polarski
Oracle DBA

-----Original Message-----

From: Syed Jaffar Hussain [mailto:sjaffarhussain_at_gmail.com] Sent: maandag 22 januari 2007 12:39
To: Polarski, Bernard
Cc: oracle-l_at_freelists.org
Subject: Re: how to evaluate optimizer_index_caching

Bernard,

I dont know whether my reply will be useful or you already might be knowing this.

Tempering with OPTIMIZER_INDEX* parameter needs very careful testing and setting other than default value to OPTIMIZER_INDEX* would result favoring NESTED LOOP.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 22 2007 - 06:05:05 CST

RE: how to evaluate optimizer_index_caching