Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Full text search

Full text search

From: Witold Iwaniec <wiwaniec_at_novalistech.com>
Date: Wed, 13 Sep 2000 08:40:45 -0300
Message-Id: <10618.116818@fatcity.com>


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 - 06:40:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US