Re: Index question
From: Mike Oswald <moswald_at_cwis.unomaha.edu>
Date: Tue, 31 Aug 1993 18:22:09 GMT
Message-ID: <1993Aug31.182209.18739_at_news.unomaha.edu>
Date: Tue, 31 Aug 1993 18:22:09 GMT
Message-ID: <1993Aug31.182209.18739_at_news.unomaha.edu>
Hans Kristian Ruud writes:
> I just got asked the following question:
>
> Suppose one has a table with a CHAR column. This column will contain both
> uppercase and lowercase text. Is it possible to put an index on the value of
> UPPER(field), rather than on the field itself?
>
> My belief is that it is not possible to do so, however, I would like the
> opinion of the net.
I don't believe you can ... in fact if you stored you u/l data and tried to search on that field you would have to have an identical match. Why not store it as upper case and return/display the info with INIT()?
Don't forget using UPPER() in your WHERE clause will cause Oracle to ignore the index.
--Mike Received on Tue Aug 31 1993 - 20:22:09 CEST