Re: Optimizer_max_permutation
- From: Jared Still <jkstill@xxxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 05 Mar 2004 06:43:36 -0800
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
