Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!news-out.spamkiller.net!propagator2-maxim!news-in.spamkiller.net!news02.tsnz.net!newsfeed01.tsnz.net!news.xtra.co.nz!53ab2750!not-for-mail
Message-ID: <3DA5EC4B.6040206@team.xtra.co.nz.nospam>
From: Thomas Hesse <thomas.hesse@team.xtra.co.nz.nospam>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4.1) Gecko/20020508 Netscape6/6.2.3
X-Accept-Language: en-us
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Alternatives to Intermedia Context Index
References: <7377f06c.0210082103.575f9661@posting.google.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 31
Date: Fri, 11 Oct 2002 10:08:27 +1300
NNTP-Posting-Host: 202.27.185.77
X-Complaints-To: newsadmin@xtra.co.nz
X-Trace: news.xtra.co.nz 1034284128 202.27.185.77 (Fri, 11 Oct 2002 10:08:48 NZDT)
NNTP-Posting-Date: Fri, 11 Oct 2002 10:08:48 NZDT
Organization: Xtra
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163783
X-Received-Date: Thu, 10 Oct 2002 14:08:44 MST (news.easynews.com)

Are you sure that standard edition does not support intermedia context ?

James wrote:

> Hi,
> 
> We are migrating from Enterprise Edition to Standard Edition and we
> have a keyword search on our website that uses an Intermedia Context
> index.
> 
> As Standard Edition does not support Intermedia, can anyone suggest a
> strategy to allow a fast keyword search on a single field
> varchar2(2000)
> 
> Before I used Intermedia i tokenised the keyword(s) and did an instr
> search.
> 
> ie
> where instr(keyword_field,keyword1)>0 and
> instr(keyword_field,keyword2)>0 ...
> 
> Do you think I could just go back to this method? Is there a paticular
> index I can create to improve performance? Or some other soloution?
> 
> Thanks in advance.
> 
> Regards,
> James Crockart
> Carsales.com.au
>