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

On Thu, 2 Sep 1999 19:18:54 +0200, "Michael Keppler" <Michael.Keppler_at_bigfoot.com> 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.
>
>--
>Michael Keppler, MCSE
>IT logic GbR
>Michael.Keppler_at_gmx.de

CREATE INDEX uppercase_idx ON yxz (UPPER(charcolumn)) should do the trick in Oracle 8i. I think that older versions of Oracle don't support function based indexes. Received on Sun Sep 05 1999 - 11:00:42 CDT