Re: Please help me on this Performance issue

When you *know* your data is in Ucase, "where field = upper(queried entry)" should use an index on field

kush wrote:

> 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 - 16:01:19 CDT