10gR211gR2method_optoptimizerOracle

Optimizer Statistics Whitepaper

The CBO team has released two white papers on Optimizer.The first paper was released in Nov 2011, which was titled “Understanding Optimizer Statistics” and this month Apr 2012, they have released “Best Practices for Gathering Optimizer Statistics”. I would say its a must read.
https://blogs.oracle.com/optimizer/entry/lies_damned_lies_and_statistics
https://blogs.oracle.com/optimizer/entry/lies_damned_lies_and_statistics1
Also Timur Akhmadeev has started Poll on the METHOD_OPT value you are using for optimizer statistics gathering….So check it out and vote!!!!
http://timurakhmadeev.wordpress.com/2012/04/09/method_opt/

Leave a Reply