On Fri, 14 Jan 2005, Connor McDonald wrote: > "Mr CBO, I don't care how long as it takes, go and know yourself out > finding a the best plan - get some more stats if you have to, do > some dynamic sampling if needed, but make sure the information that > comes out gives me a damn close to optimal plan" Wait, are you addressing Jonathan? Maybe we need a Mr. CBO competition at IUOG every year, kind of like Miss Universe. We'll have the Mr. CBO and Miss Buffer Cache competition. -- Jeremiah Wilton ORA-600 Consulting Emergencies - Seminars - Hiring http://www.ora-600.net -- //www.freelists.org/webpage/oracle-l