RE: concatenated index

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