| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rule Based Optimizer
Same here. Hopefully 10i's CBO has matured.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Wednesday, June 11, 2003 1:16 PM
To: Multiple recipients of list ORACLE-L
I know that the CBO existed on Oracle 7.0.15 for HP-UX. I remember it well because we would frequently get incorrect and inconsistent results. Installing the 7.0.16 patch _mostly_ fixed these issues.
We still had a large number of queries that we hinted to use the RBO as we couldn't get the desired query performance with the CBO
Kevin
-----Original Message-----
Sent: Wednesday, June 11, 2003 12:55 PM
To: Multiple recipients of list ORACLE-L
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
>
-- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Toepke 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: 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).Received on Wed Jun 11 2003 - 11:55:48 CDT
 |
 |