Re: Rule Based Optimizer

CBO came in with Oracle7, so that means 7.0.x onwards. The marketing literature said so :-)

• Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, June 11, 2003 11:45 AM

> 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. :)
>
> Jared
>
>
>
>
>
>
> "Ryan" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 06/10/2003 04:19 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject: Re: Rule Based Optimizer
>
>
> there not really quitting cold turkey.... its been phased out. wasnt the
> CBO
> introduced in 1997? Or was it earlier than that.
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, June 10, 2003 6:44 PM
>
>
> > RWB,
> >
> > I'll tell you, if KG says it about Oracle, I pretty much would go to the
> > bank with it.
> >
> > RF
> >
> > -----Original Message-----
> > To: Multiple recipients of list ORACLE-L
> > Sent: 6/10/2003 4:24 PM
> >
> >
> > Mr. Gopalakrishnan:
> >
> > How do you know this? Can anyone confirm (or deny) this? I hope it is
> > true!
> > Oracle should just quit cold turkey and not support the RULE optimizer
> > at
> > all in any future releases.
> >
> > RWB
> > ========================================================================
> > ====================================
> >
> > Reginald W. Bailey
> > IBM Global Services - ETS SW GDSD - Database Management
> > Your Friendly Neighborhood DBA
> > 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
> > ========================================================================
> > ====================================
> >
> >
> >
> >
> > [EMAIL PROTECTED]
> >
> > .com To: [EMAIL PROTECTED]
> >
> > Sent by: cc:
> >
> > [EMAIL PROTECTED] Subject: RE: Rule Based
> > Optimizer
> > ity.com
> >
> >
> >
> >
> >
> > 06/10/2003
> >
> > 12:59 PM
> >
> > Please respond
> >
> > to ORACLE-L
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > RULE optimizer will not be supported in next version.
> > But you can still use the RULE optimizer and it is
> > just a matter of official support from Oracle.
> >
> > Best Regards,
> > K Gopalakrishnan
> >
> >
> >
> >
> > -----Original Message-----
> > Goulet, Dick
> > Sent: Tuesday, June 10, 2003 10:16 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > There appears to be a number of folks on the list who have some insight
> > into
> > the next version of the database. I'd like to ask those folks a simple
> > question. What is the future of the Rule Based Optimizer looking like?
> > Does it die in 10i??
> >
> > Dick Goulet
> > Senior Oracle DBA
> > Oracle Certified 8i DBA
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Goulet, Dick
> > 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: K Gopalakrishnan
> > 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:
> > 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: Freeman Robert - IL
> > 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: Ryan
> 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:
> 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: Binley Lim
  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).