sorry, the second query uses equality operator..
WHERE UPPER(col1) = 'xyz';
index hint is not helping.
regards,
B S Pradhan
----------------------
On Thu, 08 Jan 2004 zions swordfish wrote :
>hi, pradhan,
>I don't see any kind of differences with your two queries, but
>I suggest you to use hint in your query to activate index.
>Regards,
>Sony
>
>--------- Original Message ---------
>DATE: Thu, 08 Jan 2004 07:09:26
>To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
>Cc:
>
>
>
>Hi All,
>
>I have the query like:
>
>SELECT *
> FROM tab1
>WHERE UPPER(col1) <> 'abc';
>
>Obviously, the function based index i have is not hetting used because of the ineqality.
>
>When using
>SELECT *
> FROM tab1
>WHERE UPPER(col1) <> 'abc';
>
>index is getting used.
>
>How can I possibly use index in the 1st case.
>
>
>Thanks and Regards,
>B S Pradhan
>
>
>
>
>
>
>____________________________________________________________
>Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
>http://login.mail.lycos.com/r/referral?aid=27005
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: bhabaniindia_at_rediffmail.com
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: ListGuru_at_fatcity.com (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).
Received on Fri Jan 09 2004 - 02:24:26 CST
