RE: Re: Desupport of RBO

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).