Re: Full text search

From: Oliver Artelt <oli_at_md.transnet.de>
Date: Wed, 13 Sep 2000 15:27:24 +0200
Message-Id: <10618.116824@fatcity.com>

Hi,
what's with the intermedia-context option? These algorithms are nearly mystic.

oli

On Wed, 13 Sep 2000, Witold Iwaniec wrote:
> Hi all
>
> In our product we have to support long text fields so we use
> columns defined as VARCHAR2 (2000)
> It seems to do the job but we are looking for a way to enable full
> text search.
>
> Running statements like:
> 'SELECT text_value FROM client_note WHERE text_value LIKE
> '%SPEED%'
>
> would be very slow and always require full table scan. Is there a
> better way of doing it, especially in the Oracle 8i world?
>
> Thanks
>
> Witold
>
> ======================================
> Witold Iwaniec
> Senior Software Developer
> NovaLIS Technologies
> wiwaniec_at_novalistech.com
> http://www.novalistech.com
Received on Wed Sep 13 2000 - 08:27:24 CDT