Re: Please help me on this Performance issue

One option is to add OMNIDEX keyword indexing, which is caseinsensitive.  See http://www.disc.com/keyword.html or contact me for more information.

Cheryl Grandy
DISC
cgrandy_at_disc.com
303 444-4000
www.disc.com/home

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
>
>

--
Cheryl Grandy
DISC
Get OMNIDEX for the fastest
applications ever


Sent via Deja.com http://www.deja.com/
Before you buy.