A similar approach is to set optimizer_mode to rule but analyze everything and then use the FIRST_ROWS/ALL_ROWS/CHOOSE hint on custom queries...
Still, RBO is a step back into the dark ages...No hash join, no cpu costing, no function based indexes, no etc etc etc etc Cheers Connor --- Jared Still <[EMAIL PROTECTED]> wrote: > On Friday 31 January 2003 07:09, Michael Fontana > wrote: > > > > Still, some of the queries in Siebel SEEM to run > better using CBO. Is > > there any way to mix and match approaches? To use > RBO by default, but > > perhaps CBO might make sense for certain queries, > and perhaps some > > AD-HOC? > > The problem with using CBO for 'some' queries is > that analyzing a table > turns on CBO for every query the table is used in, > not just the ones > you wish. > > Tony's approach sounds interesting enough to make me > start playing > with plan stabilility. Like I don't have enough to > do. :) > > Jared > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Jared Still > 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). > ===== Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
