Re: Alternatives to Intermedia Context Index

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:27:06 CDT