Re: Optimizer_max_permutation

These parameters are dependent on database statistics and
influence the cost based optimizer.

see:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/optimops.htm#47016
or
http://tinyurl.com/2f4gt

This is under the subhead "Controlling the Behavior of the CBO"

Jared


On Thu, 2004-03-04 at 22:35, Satheesh.Babu@xxxxxxxxxxxxxxxxxx wrote:
> Hi,
> 
>   
> Optimizer_max_permutation/optimizer_index_caching/optimizer_index_cost_adj is 
> only specific to COST optimizer or even it can influence the RULE optimizer?
> 
>  
> 
> Thanks and Regards,
> 
> Satheesh Babu.S
> 
> Bangalore
> 
> 
> DISCLAIMER:
> This message contains privileged and confidential information and is
> intended only for the individual named.If you are not the intended
> recipient you should not disseminate,distribute,store,print, copy or
> deliver this message.Please notify the sender immediately by e-mail if
> you have received this e-mail by mistake and delete this e-mail from
> your system.E-mail transmission cannot be guaranteed to be secure or
> error-free as information could be
> intercepted,corrupted,lost,destroyed,arrive late or incomplete or
> contain viruses.The sender therefore does not accept liability for any
> errors or omissions in the contents of this message which arise as a
> result of e-mail transmission. If verification is required please
> request a hard-copy version. 

----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: