RE: Re: Desupport of RBO

from Chap. 1 of "Oracle Database 10g New Features" on http://otn.oracle.com/oramag/webcolumns/2003/techarticles/new_features_previ ew.pdf

"The Rule Based Optimizer (RBO) is desupported with Oracle Database 10 g. It 's still
there in Oracle Database 10 g, but Oracle is moving away from it quickly and you will
find no bug fixes associated with it in future versions of the database."

Henry

-----Original Message-----
Cary Millsap
Sent: Tuesday, October 07, 2003 11:20 PM To: Multiple recipients of list ORACLE-L

I'm pretty sure that RBO is *gone* in 10g. If I understood correctly what I learned this week, there will be no more RBO, just one optimizer code path called the Oracle Query Optimizer. Also, if I understand correctly, the "RULE" hint will have exactly the same functionality as the "HEY, DUDE" hint: none.

...But I haven't tested it.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:

- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...

-----Original Message-----
rgaffuri_at_cox.net
Sent: Tuesday, October 07, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L

i dont think they are totally removing the RBO from 10g. Ive seen conflicting reports. I think tom kyte hinted that it is gone, then I read somewhere else that its still going to be there.

RBO is necessary if you use layered complex views. CBO often times doesnt hold up. Its a pretty bad design. But some people use it. I see it mostly with cross-platform apps. They tell you to always use RBO.

if the RBO is totally gone they will need to totally re-architecture their products. So I dont know if Oracle will do this.
>
> From: Kip.Bryant_at_Vishay.com
> Date: 2003/10/07 Tue PM 02:04:31 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Re: Desupport of RBO
>
> OK, dumb question. Does this mean the rule hint won't be possible?
> Application I support mostly uses CBO but there have been cases where
we had to
> resort to RBO hint. 'course it'll be some time before we can consider
v10...
>
> Kip
>
> |Hi Jared,
>
> |haven't seen it, too. But the fact
> |was spreaded over the newsgroups.
>
> |We still have some 3rd party apps that don't use
> |*any* feature above Oracle 7 (well, almost). Queries with
> |the RULE hint where it's not necessary.
> |But if we change a thing, support will be lost.
> |So we decided to rewrite the whole app.
> |Lucky me: enough work for the next years.
>
> |Greetings,
> |Guido
>
> |>>> Jared.Still_at_radisys.com 07.10.2003 01.34 Uhr >>>
> |First time I've seen this note: 189702.1
>
> |Jared
>
> |--
> |Please see the official ORACLE-L FAQ: http://www.orafaq.net
> |--
> |Author: Guido Konsolke
> | INET: Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com
>
> |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: ListGuru_at_fatcity.com (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: Kip.Bryant_at_Vishay.com
>
> 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: ListGuru_at_fatcity.com (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: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

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: ListGuru_at_fatcity.com (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: Cary Millsap
  INET: cary.millsap_at_hotsos.com

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: ListGuru_at_fatcity.com (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: Henry Poras
  INET: hporas_at_etal.uri.edu

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: ListGuru_at_fatcity.com (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).