Re: Desupport of RBO

I'm pretty sure that RBO is still there in 10g :-), but that it will not be enhanced, P2 and beyond issues won't be fixed, etc. But to be certain, I have asked Graham Wood.

Mogens

Cary Millsap wrote:

>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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_miracleas.dk

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