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 From: "bhabani s pradhan" <[EMAIL PROTECTED]> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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!
Login To Lycos Mail