We ran CBO on 7.0.13...It was not until many many many years later after much heartache and pain that a metalink note appeared saying "do not run CBO until 7.1.6"
:-( --- K Gopalakrishnan <[EMAIL PROTECTED]> wrote: > Not true. IIRC the first Oracle version with dual > optimizer mode > was 7.1.x. > > Best Regards, > K Gopalakrishnan > > > > > -----Original Message----- > Mercadante, Thomas F > Sent: Wednesday, June 11, 2003 9:30 AM > 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: 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). ===== Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __________________________________________________ Yahoo! Plus - For a better Internet experience http://uk.promotions.yahoo.com/yplus/yoffer.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
