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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Best way to search a large VARCHAR2 column

Re: Best way to search a large VARCHAR2 column

From: Gerhard Moeller <Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de>
Date: Wed, 08 Apr 1998 09:23:15 GMT
Message-ID: <6gffpe$78n@news.Informatik.Uni-Oldenburg.DE>


"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
Received on Wed Apr 08 1998 - 04:23:15 CDT

Original text of this message

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