Re: Optimizer_max_permutation

From: Jared Still <jkstill_at_cybcon.com>
Date: Fri, 05 Mar 2004 06:43:36 -0800
Message-Id: <1078497816.11042.10674.camel@poirot>

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_at_iflexsolutions.com 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_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 Fri Mar 05 2004 - 08:46:23 CST