Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!rutgers!apple!voder!cullsj!gupta
From: gupta@cullsj.UUCP (Yogesh Gupta)
Newsgroups: comp.databases
Subject: Re: Using Indexes in Oracle
Summary: But that does not use the index, if any, on that column.
Message-ID: <497@cullsj.UUCP>
Date: 16 Feb 89 02:07:45 GMT
References: <6555@bunny.UUCP> <11813@grebyn.COM>
Distribution: na
Organization: Cullinet Software, San Jose, CA
Lines: 10

In article <11813@grebyn.COM>, jan@grebyn.COM (Jan Baron) writes:
> An easy way to get around this is as follows:
> 
> select * from tablename where upper(columnname) = upper(comparestring);
> 
But if you have an index on columnname, you would not use it, which
was the original poster's question.
-- 
Yogesh Gupta                    | If you think my company will let me
Cullinet Software, Inc.         | speak for them, you must be joking.