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