RE: Rule Based Optimizer

Much as I hate to say that Jared's confidence in Mogens is misplaced, we must all remember Mogens has now reached the grand old age of 42 and the brain cells are starting to slip. :)

To be absolutely 100% picky and correct, there was an event setting introduced in (I believe) 6.0.27-ish that you could use to turn on the CBO. However, Mogens is correct in that it was first officially released and supported in the first Production release of Oracle7, 7.0.13.

Sorry, Mogens, couldn't resist! :)

Pete

"Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook

"Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long term Oracle DBA.

-----Original Message-----
Mogens Nørgaard
Sent: Tuesday, June 10, 2003 7:55 PM
To: Multiple recipients of list ORACLE-L

Thanks for the confidence, Jared. It was introduced in 7.0 and the world

hasn't been the same since.

Mogens

Jacques Kilchoer wrote:

>I am 99% confident that I remember the CBO existing on VAX/VMS in
7.1.5, and
>for sure in 7.1.6 (on VAX/VMS)
>
>
>
>>-----Original Message-----
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>>
>>I first saw the CBO in 1994 if IIRC.
>>
>>Seems to me it was introduced in 7.2.
>>
>>I'm sure Mogens knows for sure. :)
>>
>>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).