Re: Why the optimizer is not choosing the best plan?

From: mhthomas <qnxodba@xxxxxxxxx>
To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 20 Oct 2004 20:56:28 -0400

Sami,

My suggestion:
Just re-emphasizing. If you learn how to interpret 10053 trace, this
investment will allow you to precisely determine CBO choices.

Details:
If you want some 10053 guidance, I have not found much published on
the topic. A couple references have already been made to Wolfgang's
stuff. I learned a lot about 10053 from Jonathan Lewis' 3-day NYC
seminar, so I recommend his course for details on this topic.

Others may suggest additional references (backed by examples, and test cases)?

HTH

Regards,

Mike Thomas
--
http://www.freelists.org/webpage/oracle-l

References:

RE: Why the optimizer is not choosing the best plan?
From: Christian Antognini

Re: Why the optimizer is not choosing the best plan?

Other related posts: