Re: Alternatives to Intermedia Context Index

From: Thomas Hesse <thomas.hesse_at_team.xtra.co.nz.nospam>
Date: Fri, 11 Oct 2002 10:08:27 +1300
Message-ID: <3DA5EC4B.6040206@team.xtra.co.nz.nospam>

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
>
Received on Thu Oct 10 2002 - 16:08:27 CDT