Certainly a lot of the recursive SQL I've seen in traces is riddled with ORDERED, FIRST_ROWS or a long explicit list (ala outline style) hints
You get the feeling it was: - explain SQL under RBO - not down plan - craft hints to make sure it does it under CBO Cheers Connor --- Tim Gorman <[EMAIL PROTECTED]> wrote: > RE: But I *want* to use RBO!The well-known problems > with using CBO to query the statistics-less data > dictionary had been resolved in Oracle9i, as > discussed in an earlier thread on this list. Not > sure how they fixed it, but I suspect that Oracle is > not throwing away the RBO code-base, but rather > absorbing the more useful parts of it into the CBO > for uses like querying the data dictionary. Either > that, or they have improved the constants applied in > the absence of statistics. Or both...? > ----- Original Message ----- > From: Jacques Kilchoer > To: Multiple recipients of list ORACLE-L > Sent: Tuesday, October 08, 2002 1:54 PM > Subject: RE: But I *want* to use RBO! > > > > -----Original Message----- > > From: Jesse, Rich > [mailto:[EMAIL PROTECTED]] > > > > No more RBO as of 10i... > > > > > http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=189702.1 > > > Does this mean Oracle is getting rid of their data > dictionary too? :) > > ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __________________________________________________ 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.com -- 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).
