Re: Please help me on this Performance issue

Hi

What I would consider doing is storing the data in upper case only in the database & then using logic on the web form to pass the search string in upper case. You would of course lose the ability to query mfor mixed case, but it sounds like that is what this guy wants

Niall Litchfield
Insomniac.
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:971331077.26243.0.pluto.d4ee154e_at_news.demon.nl...
> 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 Thu Oct 12 2000 - 16:31:42 CDT