> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Mark Richard > Sent: 08 July 2003 06:09 > To: Multiple recipients of list ORACLE-L > Subject: Re: concatenated index > > > > I didn't mean that including RULE will prevent the index from > being used - I should have explained myself better. When > using the RULE based optimisor the order of joins in the > where clause becomes significant, I don't believe the order > of selection criteria is significant (although I have very > little experience with the rule based optimisor and could > easily be proven wrong). > > If you really don't want Oracle to use the index (and > assuming statistics are correct but you know something Oracle > doesn't) then try: > > /*+ NO_INDEX(test) */
I think that should read /*+ FULL(test) */ Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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).
