RE: Rule Based Optimizer

I hope this isn't true, since I just gave a presentation listing 13.....

Niall

> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of John Kanagaraj
> Sent: 11 June 2003 18:09
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Rule Based Optimizer
>
>
> Tom,
>
> I think you meant 'RBO' in 5.x and 6.0 rather than CBO...
> There were the 15 rules.
>
> John
>
> > -----Original Message-----
> > From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, June 11, 2003 9:30 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Rule Based Optimizer
> >
> >
> > CBO was what I learned on in late version of 5.x and 6.0.
> It was what
> > Oracle taught developers back then - with the chart showing the
> > precedence of how indexes were selected for a spcific
> query. And how
> > the order of the
> > tables in the FROM clause was *very* important in telling the
> > CBO how to
> > operate. Of course, that was when the developers had to know
> > everything
> > about the data within all the tables to get things to work right.
> >
> > Tom Mercadante
> > Oracle Certified Professional
> >
> >
> > -----Original Message-----
> > Sent: Wednesday, June 11, 2003 11:50 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > I remember CBO in 7.1.6 on AIX...
> >
> > RF
> >
> > -----Original Message-----
> > To: Multiple recipients of list ORACLE-L
> > Sent: 6/10/2003 6:45 PM
> >
> > 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: 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: Mercadante, Thomas F
> > 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: John Kanagaraj
> 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: Niall Litchfield
  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).