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 O
: [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
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
36 matches
Mail list logo