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? 


Other related posts: