Re: Best way to search a large VARCHAR2 column

"Colin Sutherland" <c.sutherland_at_easynet.com> wrote:

>I would use the INSTR built in function. You can look it up in the
>documentation.

This will do a seqscan.

>Colin.
>Suwat Phruksawan wrote in message <6ffm47$6rg_at_argentina.earthlink.net>...
>>What is the best way to do a search for keywords on a large (up to 2000)
>>VARCHAR2 column. Basically, I tried to avoid sequential search, one record
>>at a time. And make the index on that particular column seems expensive.

You cannot build a index on more than a VARCHAR2(749) (at least in Oracle 7.3).

Sou you would either have to use Oracle ConText or some third party product if you do not want to code something like a keyword search table yourself.

        Gerhard
--
Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE

                                      ICQ PIN: 2804938
OFFIS                  | | | | | |    Tel.:    0441/9722-122
Escherweg 2            | | | | | |    Sekr.:   0441/9722-113 oder -101
D-26121 Oldenburg      |O|F|F|I|S|    Fax:     0441/9722-102