RE: Why the optimizer is not choosing the best plan?
From: ryan_gaffuri@xxxxxxxxxxx
To: JozeS@xxxxxxxxxxxxxx, <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 21 Oct 2004 13:30:56 +0000
we are using system stats here and we have noticed absolutely no difference
whatsoever in oracles ability to make the best plan over using optimizer
parameters. I've also noticed that even with bad optimizer init.ora settings in
9.2 the CBO is still write about 99% of the time.
with decent settings that improves to 99.5% of the time. so if system stats
helps its minimal.
-------------- Original message --------------
> If you are on 9i then you should try to gather system statistics. This =
> may change the join method from NL to HJ.
>
> Regards, Joze=20
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx =
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Sami Seerangan
> Sent: Wednesday, October 20, 2004 9:49 PM
> To: Oracle Discussion List
> Subject: Why the optimizer is not choosing the best plan?
>
--
http://www.freelists.org/webpage/oracle-l
