RE: how to evaluate optimizer_index_caching
- From: "Polarski, Bernard" <Bernard.Polarski@xxxxxxxxxxxxxx>
- To: <sjaffarhussain@xxxxxxxxx>,<oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 22 Jan 2007 13:05:05 +0100
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@xxxxxxxxx]
Sent: maandag 22 januari 2007 12:39
To: Polarski, Bernard
Cc: oracle-l@xxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
