subject:"RE\: Re\: Rule Based Optimizer"

RE: RE: Rule Based Optimizer

2003-06-12 Thread Niall Litchfield

I haven't been around that long, but the RBO stands for the Rule Based
Optimizer, it works on a set of rules - best thought of as a
mathematical precedence list. You know the sort of thing Full Table Scan
is worse than anything, a range scan isn't as good as an equality test,
etc etc. 

Now the thing is SQL is an abstracted language to specify what results
should be returned, irrespective of physical storage, so it *has* to be
translated into data retrieval instructions somehow, if not on the basis
of rules (this is better than that), then how. Of course this doesn't
say what rules are included in what release, and I'm sure that changed
from version to version, but there must have been some. My own view is
that starting with (effectively version 8) version 7 Oracle changed the
ball park from 'Optimum data access is best determined by rating the
access methods against a fixed hierarchy' to 'Optimum data access is
best determined by estimating how much work I will have to do, given
what I know about the system' I.E we've replaced a number of rules with
1 'see how much work is required for each avaialable option and Do the
least work necessary'. 

Niall 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of [EMAIL PROTECTED]
> Sent: 11 June 2003 19:10
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: Rule Based Optimizer
> 
> 
> 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

RE: Re: Rule Based Optimizer

2003-06-11 Thread Babette Turner-Underwood

I think Wolfgang did a presentation on the NBO recently, so you should ask
him ;-)

- Babette

-Original Message-
Hallas, John, Tech Dev
Sent: Wednesday, June 11, 2003 10:25 AM
To: Multiple recipients of list ORACLE-L


No it was just BO  - and it stunk

-Original Message-
Sent: 11 June 2003 14:20
To: Multiple recipients of list ORACLE-L


Perhaps MBO (Mood Based Optimizer)!

- Original Message -
To: Multiple   recipients of list ORACLE-L
Sent: Wednesday, June 11, 2003 7:39 AM

what did oracle use before the RBO?
>
> From: Mogens Nørgaard < [EMAIL PROTECTED]>
> Date: 2003/06/11 Wed AM 12:39:20 EDT
> To: Multiple recipients of list ORACLE-L < [EMAIL PROTECTED]>
> Subject: Re: Rule Based Optimizer
>
> Yep. Here's the official statement from Oracle about RBO in 10i:
>
> "The RBO is Oracle's legacy optimizer originating from Oracle Version 6
> and earlier. The RBO is being desupported in Oracle10i. The RBO will
> still exist in Oracle10i, but will be an unsupported feature and will be
> removed in a future release. No code changes will be made to the RBO
> code and no bug fixes will be provided. The RBO was superseded in
> Oracle7 by the CBO and has continued to be available for backwards
> compatibility. Oracle Oracle10i will support only one optimizer, and all
> applications running on that release should use that optimizer. "
>
> What's behind this wording? I don't really know, but I can guess.
> There's a myth that the RBO hasn't been enhanced since the introduction
> of CBO in 7.0. That, I learned one day in Steve Adams' car, is not true.
> It has been enhanced to know about new segment types, etc. A fun (well,
> fun...) exception to this is partitions. If you're using partitions
> you're using CBO.
>
> So I read it as: "Yeah, we haven't really enhanced the RBO since 7.0
> except to allow it to recognize IOT's and other new segment types. In
> 10i we won't even do that."
>
> Mogens
>
> Freeman Robert - IL wrote:
>
> >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, Califo

RE: RE: Rule Based Optimizer

2003-06-11 Thread Goulet, Dick

RBO was the optimizer as far back as I can remember and that was V3.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Wednesday, June 11, 2003 2:10 PM
To: Multiple recipients of list ORACLE-L


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:

Re: RE: Rule Based Optimizer

2003-06-11 Thread rgaffuri

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 ot

RE: Re: Rule Based Optimizer

2003-06-11 Thread Hallas, John, Tech Dev

No it was just BO  - and it stunk

-Original Message-
Sent: 11 June 2003 14:20
To: Multiple recipients of list ORACLE-L


Perhaps MBO (Mood Based Optimizer)!

- Original Message - 
To: Multiple   recipients of list ORACLE-L 
Sent: Wednesday, June 11, 2003 7:39 AM

what did oracle use before the RBO? 
> 
> From: Mogens Nørgaard < [EMAIL PROTECTED]>
> Date: 2003/06/11 Wed AM 12:39:20 EDT
> To: Multiple recipients of list ORACLE-L < [EMAIL PROTECTED]>
> Subject: Re: Rule Based Optimizer
> 
> Yep. Here's the official statement from Oracle about RBO in 10i:
> 
> "The RBO is Oracle's legacy optimizer originating from Oracle Version 6 
> and earlier. The RBO is being desupported in Oracle10i. The RBO will 
> still exist in Oracle10i, but will be an unsupported feature and will be 
> removed in a future release. No code changes will be made to the RBO 
> code and no bug fixes will be provided. The RBO was superseded in 
> Oracle7 by the CBO and has continued to be available for backwards 
> compatibility. Oracle Oracle10i will support only one optimizer, and all 
> applications running on that release should use that optimizer. "
> 
> What's behind this wording? I don't really know, but I can guess. 
> There's a myth that the RBO hasn't been enhanced since the introduction 
> of CBO in 7.0. That, I learned one day in Steve Adams' car, is not true. 
> It has been enhanced to know about new segment types, etc. A fun (well, 
> fun...) exception to this is partitions. If you're using partitions 
> you're using CBO.
> 
> So I read it as: "Yeah, we haven't really enhanced the RBO since 7.0 
> except to allow it to recognize IOT's and other new segment types. In 
> 10i we won't even do that."
> 
> Mogens
> 
> Freeman Robert - IL wrote:
> 
> >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 fro

Re: Re: Rule Based Optimizer

2003-06-11 Thread Arup Nanda




Perhaps MBO (Mood Based Optimizer)!

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, June 11, 2003 7:39 
  AM
  Subject: Re: Re: Rule Based 
  Optimizer
  what did oracle use before the RBO? > > From: 
  Mogens Nørgaard <[EMAIL PROTECTED]>> Date: 
  2003/06/11 Wed AM 12:39:20 EDT> To: Multiple recipients of list 
  ORACLE-L <[EMAIL PROTECTED]>> 
  Subject: Re: Rule Based Optimizer> > Yep. Here's the official 
  statement from Oracle about RBO in 10i:> > "The RBO is Oracle's 
  legacy optimizer originating from Oracle Version 6 > and earlier. The 
  RBO is being desupported in Oracle10i. The RBO will > still exist in 
  Oracle10i, but will be an unsupported feature and will be > removed in 
  a future release. No code changes will be made to the RBO > code and no 
  bug fixes will be provided. The RBO was superseded in > Oracle7 by the 
  CBO and has continued to be available for backwards > compatibility. 
  Oracle Oracle10i will support only one optimizer, and all > 
  applications running on that release should use that optimizer. "> 
  > What's behind this wording? I don't really know, but I can guess. 
  > There's a myth that the RBO hasn't been enhanced since the 
  introduction > of CBO in 7.0. That, I learned one day in Steve Adams' 
  car, is not true. > It has been enhanced to know about new segment 
  types, etc. A fun (well, > fun...) exception to this is partitions. If 
  you're using partitions > you're using CBO.> > So I read 
  it as: "Yeah, we haven't really enhanced the RBO since 7.0 > except to 
  allow it to recognize IOT's and other new segment types. In > 10i we 
  won't even do that."> > Mogens> > Freeman Robert - 
  IL wrote:> > >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

Re: Re: Rule Based Optimizer

2003-06-11 Thread rgaffuri

what did oracle use before the RBO? 
> 
> From: Mogens Nørgaard <[EMAIL PROTECTED]>
> Date: 2003/06/11 Wed AM 12:39:20 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Rule Based Optimizer
> 
> Yep. Here's the official statement from Oracle about RBO in 10i:
> 
> "The RBO is Oracle's legacy optimizer originating from Oracle Version 6 
> and earlier. The RBO is being desupported in Oracle10i. The RBO will 
> still exist in Oracle10i, but will be an unsupported feature and will be 
> removed in a future release. No code changes will be made to the RBO 
> code and no bug fixes will be provided. The RBO was superseded in 
> Oracle7 by the CBO and has continued to be available for backwards 
> compatibility. Oracle Oracle10i will support only one optimizer, and all 
> applications running on that release should use that optimizer. "
> 
> What's behind this wording? I don't really know, but I can guess. 
> There's a myth that the RBO hasn't been enhanced since the introduction 
> of CBO in 7.0. That, I learned one day in Steve Adams' car, is not true. 
> It has been enhanced to know about new segment types, etc. A fun (well, 
> fun...) exception to this is partitions. If you're using partitions 
> you're using CBO.
> 
> So I read it as: "Yeah, we haven't really enhanced the RBO since 7.0 
> except to allow it to recognize IOT's and other new segment types. In 
> 10i we won't even do that."
> 
> Mogens
> 
> Freeman Robert - IL wrote:
> 
> >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 subsc

RE: RE: Rule Based Optimizer

RE: Re: Rule Based Optimizer

RE: RE: Rule Based Optimizer

Re: RE: Rule Based Optimizer

RE: Re: Rule Based Optimizer

Re: Re: Rule Based Optimizer

Re: Re: Rule Based Optimizer

7 matches

Site Navigation

Mail list logo

Footer information