Re: Please help me on this Performance issue

Not much you can do here.

One thing you can try is to only store string text in one case (either upper or lower) in the column. Therefore your query would be like (I am using upper case):

select somecolumn(s)
from sometable
where column = upper ('text_user_type_in');

This way, the index would work. It would not do full table scan.

By the way, how big is your text column? varchar2(?). Would you want to create an index on a large varchar2 column, say varchar2(2000)?

Hope this helps.

Guang

In article <eh3F5.49$wu.2638_at_sjc-read.news.verio.net>,   "kush" <kdhakal_at_eline.com> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 11 2000 - 16:28:52 CDT