Depending on the query, in dba_extents example there are hints only in one part of multi-part union all SQL, but nevertheless, good point :)
Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, October 29, 2003 1:04 AM > If there're already hints like ordered and use_nl that tell Oracle how to join, > lack of statistics is less of a problem. In fact, you may need to use those two > hints in some queries against data dictionary even in pre-9i Oracle. > > Yong Huang > > --- Tanel Poder <[EMAIL PROTECTED]> wrote: > > Hi! > > > > Just for the record, in 9.2 some views such dba_extents use "ordered" and > > "use_nl" hints, which force usage of CBO. > > If you don't have statistics calculated nor optimizer_dynamic_sampling set > > to at least 2, then you'll be using CBO with default statistics, which > > usually are quite misleading. > > > > Tanel. > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Tuesday, October 28, 2003 11:09 PM > > > > > > > The data dictionary should not have any statistics on them and thus will > > use > > > rule as a "rule" so to speak. > > > > > > If you have run stats on the data dictionary you coul dbe running into > > some > > > odd bugs. > > __________________________________ > Do you Yahoo!? > Exclusive Video Premiere - Britney Spears > http://launch.yahoo.com/promos/britneyspears/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Yong Huang > 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: Tanel Poder 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).
