did oracle always use the RBO? or did it have some extremely simplified optimizer prior to 6.0?
i know some of you haev been around a while... hopefully this doesnt make you feel old. no real need to know. just curious how the technology has progressed over time. > > From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> > Date: 2003/06/11 Wed PM 01:25:07 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Rule Based Optimizer > > well beat me with a stick and call me black and blue. > > of *course* I meant RBO! > > Tom Mercadante > Oracle Certified Professional > > > -----Original Message----- > Sent: Wednesday, June 11, 2003 12:30 PM > To: Multiple recipients of list ORACLE-L > > > 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: 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: <[EMAIL PROTECTED] 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).