Re: function index for like '%string%'

2001-06-02 Thread Suzy Vordos
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

Re: function index for like '%string%'

2001-06-02 Thread Jared Still
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

Re: function index for like '%string%'

2001-06-02 Thread Rachel Carmichael
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

Re: function index for like '%string%'

2001-06-02 Thread Joseph S. Testa
;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

Re: function index for like '%string%'

2001-06-02 Thread Thater, William
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

Re: function index for like '%string%'

2001-06-02 Thread A. Bardeen
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

Re: function index for like '%string%'

2001-06-01 Thread SuzyV
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

Re: function index for like '%string%'

2001-06-01 Thread Joseph S. Testa
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

RE: function index for like '%string%'

2001-06-01 Thread Rachel Carmichael
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

RE: function index for like '%string%'

2001-06-01 Thread Hillman, Alex
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