7;t being used. What Suzy wants to know (and I do
> > > > too, because I have a similar situation) is if there is a way to create
> > > > an index that will let you search with the like clause.
> > > >
> > > > Unfortunately my gut instinct is th
search with the like clause.
> > >
> > > Unfortunately my gut instinct is that you can't make Oracle do that
> > >
> > > >From: "Hillman, Alex" <[EMAIL PROTECTED]>
> > > >Reply-To: [EMAIL PROTECTED]
> > > >To: M
ooh ooh a fbi with instr! can't wait until Monday to try that one out on
the table in question...
>From: "A. Bardeen" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: function i
;Hillman, Alex" <[EMAIL PROTECTED]>
> ->> >Reply-To: [EMAIL PROTECTED]
> ->> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> ->> >Subject: RE: function index for like '%string%'
> ->> >Date: Fri, 01 J
inct is that you can't make Oracle do that
->>
->> >From: "Hillman, Alex" <[EMAIL PROTECTED]>
->> >Reply-To: [EMAIL PROTECTED]
->> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
->> >Subject: RE: function index for l
ed. What Suzy
> wants to know (and I do too,
> > > because I have a similar situation) is if there
> is a way to create an index
> > > that will let you search with the like clause.
> > >
> > > Unfortunately my gut instinct is that you can't
> make Or
let you search with the like clause.
> >
> > Unfortunately my gut instinct is that you can't make Oracle do that
> >
> > >From: "Hillman, Alex" <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORAC
n index
> that will let you search with the like clause.
>
> Unfortunately my gut instinct is that you can't make Oracle do that
>
> >From: "Hillman, Alex" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORA
quot;Hillman, Alex" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: function index for like '%string%'
>Date: Fri, 01 Jun 2001 14:11:08 -0800
>
>index is not used because you have le
index is not used because you have leading % in the like predicate.
Alex Hillman
-Original Message-
Sent: Friday, June 01, 2001 5:09 PM
To: Multiple recipients of list ORACLE-L
I've created a function index for lower(column_name). However the query
does
a like comparison rather than
10 matches
Mail list logo