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 <[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! >http://login.mail.lycos.com/r/referral?aid=27005
