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.

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).