I must admit that it was a nice document on Oracle Optimizer behavior by Karen Morton. Regards, Jaffar On Tue, Feb 24, 2009 at 6:36 PM, Cary Millsap <cary.millsap@xxxxxxxxxxxx>wrote: > "Managing Statistics for Optimal Query Performance," by Karen Morton > > http://method-r.com/downloads/doc_details/11-managing-statistics-for-optimal-query-performance-karen-morton > > Cary Millsap > http://method-r.com > http://carymillsap.blogspot.com > > -- Best Regards, Syed Jaffar Hussain Oracle Certified Master (10g) http://www.oracle.com/technology/ocm/shussain.html Oracle ACE http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:126 OCP 8i,9i & 10g DBA RAC Certified Expert Official Oracle RAC SIG Representative for Saudi Arabian region ( http://www.oracleracsig.org/) I blog at http://jaffardba.blogspot.com/ -------------------- "Winners don't do different things. They do things differently."