Re: Please help me on this Performance issue

It is not possible to turn it off. Except for the Microsux Empire the whole world is case sensitive.
As an alternative you could always add an extra redundant column for which has the uppercased version of the original column, maintained by trigger and the redundant column indexed. Works quite well, but of course not suitable for all columns, but I wouldn't use function based indexes for all columns either.

Hth,

Sybrand Bakker, Oracle DBA

"kush" <kdhakal_at_eline.com> wrote in message news:eh3F5.49$wu.2638_at_sjc-read.news.verio.net...
> Hi! we are using Oracle 8 standard edition, The problem is when user does
> query from web site for text field he or she may type in Ucase or Lcase
> letter, but since Oracle is case sensitive(I believe), if I applied upper
 or
> lower function on both side of where clause it will suppress the index on
> the column causing performance problem and function based index is not
> supported on Oracle 8standard editiond. so is there any way I can turn off
> case sensitivity of oracle and if not how can I get around this problem?
 any
> hint will be appreciated. thanks.
>
> kush
>
>
Received on Wed Oct 11 2000 - 15:36:08 CDT