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----- [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > Date: 2003/10/07 Tue PM 02:04:31 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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 > > |>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > |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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).