Sorry Niall, there were 15. http://download-west.oracle.com/docs/cd/A64702_01/doc/server.805/a58227/ch13.htm#13411
Jared "Niall Litchfield" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/12/2003 11:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: 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). -- 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).