Re: Please help me on this Performance issue

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Wed, 11 Oct 2000 22:31:28 +0100
Message-ID: <39E4DC30.ABB8A756@rdbms.freeserve.co.uk>

We could also use a function based index on field to make sure the case is fixed.

Chris

frank wrote:
>
> 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:31:28 CDT