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 Certifi
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 Cert
: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Rule Based Optimizer
ECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Rule Based
Optimizer
ity.com
06/10/2003
12:
===
>
>
>
>
> [EMAIL PROTECTED]
>
> .com To: [EMAIL PROTECTED]
>
> Sent by: cc:
>
> [EMAIL PROTECTED] Subject: RE: Rule Based
> Optimiz
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 OR
I am 99% confident that I remember the CBO existing on VAX/VMS in 7.1.5, and
for sure in 7.1.6 (on VAX/VMS)
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>
> I first saw the CBO in 1994 if IIRC.
>
> Seems to me it was introduced in 7.2.
>
> I'm sure Mogens kno
ultiple 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
Thanks for the confidence, Jared. It was introduced in 7.0 and the world
hasn't been the same since.
Mogens
Jacques Kilchoer wrote:
I am 99% confident that I remember the CBO existing on VAX/VMS in 7.1.5, and
for sure in 7.1.6 (on VAX/VMS)
-Original Message-
From: [EMAIL PROTECTED] [
[EMAIL PROTECTED]
.com To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Rule Based
Optimizer
]
.com To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Rule Based
Optimizer
ity.com
06/10/2003
12:59 PM
Please respond
Paper and pen?
On Wednesday 11 of June 2003 13:39, you wrote:
> 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]>
&
ROTECTED]>
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
]>
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
e 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.
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 (Offic
n 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:
Title: RE: Rule Based Optimizer
Tom,
I thought the rules of precedence were for RBO (the R in RBO). Whereas CBO was _intelligent_ enough to choose a path based on information available on hand.
Raj
Rajendra
e 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.
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 o
6/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
E-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]
&
Much as I hate to say that Jared's confidence in Mogens is misplaced, we
must all remember Mogens has now reached the grand old age of 42 and the
brain cells are starting to slip. :)
To be absolutely 100% picky and correct, there was an event setting
introduced in (I believe) 6.0.27-ish that you
7.0.13. Ah yes, I remember that.
Mostly I remember praying that 7.0.16 would
be in the mail RSN.
Jared
On Wednesday 11 June 2003 18:14, Pete Sharman wrote:
> Much as I hate to say that Jared's confidence in Mogens is misplaced, we
> must all remember Mogens has now reached the grand old age
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 show
Yup, I remember praying exactly the same thing!
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.
-Original Message-
Jared Still
Sent: Wednesday, June 11, 2003 10
s 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
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
Pete - I love it when you talk dirty. It will probably only get worse in
the next 24 hours, since - if I recall correctly - you're having the "I'm
going back to Australia, so let's empty all the bottles in my house" party
tonight?
Thanks for the note on 6.0.27. It's funny how things are introd
12:05 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Rule Based Optimizer
Pete - I love it when you talk dirty. It will probably
only get worse in the next 24 hours, since - if I recall correctly - you're
having the "I'm going back to Australia, so let's empty all
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
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:
, 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
;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
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
>
ens 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 Or
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.
Anybody knows whether rule based optimizer can use bitmap indexes?
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
Hi,
I'm trying to do a join that is best done by a fast full scan of one
index and a lookup in another. Using the rule-based optimizer and
Oracle 8.1.6, I can't get the optimizer to do what I want. Is there a
way? Any enlightenment would be greatly appreciated.
[Yes, we are moving to
, September 12, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
Anybody knows whether rule based optimizer can use bitmap indexes?
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
No, CBO only
HTH
Vadim Gorbounov
Oracle DBA
-Original Message-
Sent: Wednesday, September 12, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
Anybody knows whether rule based optimizer can use bitmap indexes?
Alex Hillman
--
Please see the official ORACLE-L FAQ: http
partitioning, etc.). To use these features, you must set
optimizer_mode to CHOOSE, FIRST_ROWS or ALL_ROWS, which will invoke the cbo.
Jon Walthour
-Original Message-
Sent: Wednesday, September 12, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
Anybody knows whether rule based optimizer
lman, Alex"
treas.gov> cc:
Sent by: Subject: RE: bitmap indexes and
ru
Message-
Sent: Wednesday, September 12, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
Anybody knows whether rule based optimizer can use bitmap indexes?
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED
We move an application that uses
OPTIMIZER_MODE=RULE from Oracle8 to 9i. Most of it is fine, but there are two
queries that have a very different execution plan. In one case, the execution
time increases from less than a minute to more than an hour. Neither query uses
any of the new Oracle 9
sole him for what he is." --Horace
Walpole
-Original Message-From: Keith Moore
[mailto:[EMAIL PROTECTED] Sent: Friday, January 30, 2004 11:54
AMTo: Multiple recipients of list ORACLE-LSubject:
Changes to RULE based optimizer between Oracle8 and 9i
We move
:[EMAIL PROTECTED]Sent: Friday, January 30, 2004 11:54
AMTo: Multiple recipients of list ORACLE-LSubject:
Changes to RULE based optimizer between Oracle8 and 9i
We move an application that uses
OPTIMIZER_MODE=RULE from Oracle8 to 9i. Most of it is fine, but there are two
queries that
47 matches
Mail list logo
