Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Why the optimizer is not choosing the best plan?

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

From: mhthomas <qnxodba_at_gmail.com>
Date: Wed, 20 Oct 2004 20:56:28 -0400
Message-ID: <d6bad08004102017565fbfc0ae@mail.gmail.com>


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
Received on Wed Oct 20 2004 - 19:52:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US