RE: Which plan is better - what COST really means ?

From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Thu, 13 Jan 2005 22:32:53 -0800 (PST)
Message-ID: <Pine.LNX.4.60.0501132228120.3109@cpq7598>

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

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

Received on Fri Jan 14 2005 - 00:34:07 CST