Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!arclight.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: thanatic@telstra.com (James)
Newsgroups: comp.databases.oracle.server
Subject: Re: Alternatives to Intermedia Context Index
Date: 9 Oct 2002 23:27:06 -0700
Organization: http://groups.google.com/
Lines: 15
Message-ID: <7377f06c.0210092227.30b3e48@posting.google.com>
References: <7377f06c.0210082103.575f9661@posting.google.com>
NNTP-Posting-Host: 203.25.40.66
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1034231227 20002 127.0.0.1 (10 Oct 2002 06:27:07 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 10 Oct 2002 06:27:07 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163691
X-Received-Date: Wed, 09 Oct 2002 23:27:01 MST (news.easynews.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