Re: Index usage

From: zions swordfish <zettira_at_lycos.com>
Date: Thu, 08 Jan 2004 07:29:26 -0800
Message-ID: <F001.005DC270.20040108072926@fatcity.com>

Content-Type: text/plain; charset=us-ascii
Content-Language: en
Content-Length: 908
Content-Transfer-Encoding: 7bit

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_at_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

--=_-=_-MECFKJFAIOOONHAA
Content-Type: text/html; charset=us-ascii
Content-Language: en
Content-Length: 1675
Content-Transfer-Encoding: 7bit

<PRE>hi, pradhan,</PRE><PRE>I don't see any kind of differences with your two queries, but</PRE><PRE>I suggest you to use hint in your query to activate index.</PRE><PRE>Regards,</PRE><PRE>Sony
</PRE>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 4px; BORDER-LEFT: #1010ff 3px solid"><FONT face="Times New Roman" size=2>--------- Original Message ---------<BR>
<TABLE cellSpacing=0 cellPadding=0 width=800 border=0>
<TBODY>
<TR>
<TD align=left><B>DATE:</B> Thu, 08 Jan 2004 07:09:26</TD></TR>
<TR>
<TD align=left><B>From:</B> "bhabani s pradhan" &lt;bhabaniindia_at_rediffmail.com&gt;</TD></TR>
<TR>
<TD align=left><B>To:</B> Multiple recipients of list ORACLE-L &lt;ORACLE-L_at_fatcity.com&gt;</TD></TR>
<TR>
<TD align=left><B>Cc:</B> </TD></TR></TBODY></TABLE></FONT><BR>
<P><BR>Hi All,<BR><BR>I have the query like:<BR><BR>SELECT *<BR>FROM tab1<BR>WHERE UPPER(col1) &lt;&gt; 'abc';<BR><BR>Obviously, the function based index i have is not hetting used because of the ineqality.<BR><BR>When using <BR>SELECT *<BR>FROM tab1<BR>WHERE UPPER(col1) &lt;&gt; 'abc';<BR><BR>index is getting used.<BR><BR>How can I possibly use index in the 1st case.<BR><BR><BR>Thanks and Regards,<BR>B S Pradhan<BR></P><BR><BR> </BLOCKQUOTE><br><br>____________________________________________________________<br>Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!<br><a href="http://login.mail.lycos.com/r/referral?aid=27005">Login To Lycos Mail</a>
--=_-=_-MECFKJFAIOOONHAA--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: zions swordfish
  INET: zettira_at_lycos.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 Thu Jan 08 2004 - 09:29:26 CST