Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!nntp2.aus1.giganews.com!nntp.giganews.com!wn12feed!worldnet.att.net!204.127.198.204!attbi_feed4!attbi.com!rwcrnsc53.POSTED!not-for-mail
From: "Jim Kennedy" <kennedy-family@attbi.com>
Newsgroups: comp.databases.oracle.server
References: <7377f06c.0210082103.575f9661@posting.google.com> <7377f06c.0210092227.30b3e48@posting.google.com>
Subject: Re: Alternatives to Intermedia Context Index
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <5a9p9.34798$ST4.84523@rwcrnsc53>
NNTP-Posting-Host: 12.241.212.232
X-Complaints-To: abuse@attbi.com
X-Trace: rwcrnsc53 1034231553 12.241.212.232 (Thu, 10 Oct 2002 06:32:33 GMT)
NNTP-Posting-Date: Thu, 10 Oct 2002 06:32:33 GMT
Organization: AT&T Broadband
Date: Thu, 10 Oct 2002 06:32:33 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163692
X-Received-Date: Wed, 09 Oct 2002 23:35:50 MST (news.easynews.com)

Nope.  It will be a fulltable scan in either event.
Jim
"James" <thanatic@telstra.com> wrote in message
news:7377f06c.0210092227.30b3e48@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