Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alternatives to Intermedia Context Index
Nope. It will be a fulltable scan in either event.
Jim
"James" <thanatic_at_telstra.com> wrote in message
news:7377f06c.0210092227.30b3e48_at_posting.google.com...
> Would using something like:
>
> where keyword like '%keyword1%' and keyword like '%keyword2%'
>
> be better than instr?
>
> > where instr(keyword_field,keyword1)>0 and
> > instr(keyword_field,keyword2)>0 ...
> >
>
> Either way should I index the field Keyword to improve performance?
> What kind of index?
>
> Regards,
> James
Received on Thu Oct 10 2002 - 01:32:33 CDT