| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Case Insensitive Query Performance
Dean Mah wrote:
>
> This must be a FAQ....
>
> I have a table with a surname field which is mixed case. I want to do a
> case insensitive search against this field. I have used the UPPER
> function to force both the surname and my search criteria to uppercase.
> Obviously, this results in poor performance.
>
> I have tried to create an index with UPPER(surname) which didn't work.
> I've tried to create a view with UPPER(surname) which didn't work. I
> don't want to create another field with the surname in uppercase because
> there are >400K records in the table and it is growing.
>
> Any hints, ideas, solutions, ... would be greatly appreciated.
> Dean
I have seen a site that resolved this problem by having an additional column "UPPER_SURNAME" which was populated with a trigger, and then this was indexed etc etc...
I am not saying that I recommend it...hee hee
Cheers
--
"The only difference between me and a madman is that I am not mad." Received on Fri Apr 17 1998 - 23:30:05 CDT
 |
 |