not in std edition.
"Christopher M. Day" <christopher.day_at_rdbms.freeserve.co.uk> wrote in
message news:39E4DC30.ABB8A756_at_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 Thu Oct 12 2000 - 16:29:18 CDT
