Re: index to speed up UPPER(column) ??

A copy of this was sent to "Michael Keppler" <Michael.Keppler_at_bigfoot.com> (if that email address didn't require changing) On Thu, 2 Sep 1999 19:18:54 +0200, you wrote:

>Hello everybody !
>
>In some of our queries it's import to find data wether it is uppercase
>or lowercase. If I define an index on the column with the chars I don't
>get any speedup if I do
>SELECT abc from yxz
>WHERE UPPER(charcolumn)=:myparam
>(myparam comes from a delphi program)
>
>Is there a way to define some kind of index, that will speedup the query
>? Or do I have another possibility to get a fast selection that doesn't
>make differences between uppercase, lowercase and mixtures of them (I
>think in SQL-Server it is an installation option)?
>
>Ciao and Thanks, Michael.

In oracle8i, release 8.1 you can index functions. if you want to read about it (funtion based indexes) see my web site below.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Sep 02 1999 - 14:02:23 CDT