Re: Best way to search a large VARCHAR2 column

From: Mike Medved <medved_at_netcom.com>
Date: 1998/04/03
Message-ID: <medvedEqtFn7.L2E@netcom.com>#1/1

INSTR would perform a table scan - okay if you have small tables but extremely slow on large amount of data.

Check out http://home.earthlink.net/~golbert/idxsrch.htm This is a DLL that will allow you to index the strings you want by keyword and do boolean keyword searches on them afterwards very fast.

Colin Sutherland (c.sutherland_at_easynet.com) wrote: : I would use the INSTR built in function. You can look it up in the : documentation.  

: 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.
: >
: >Any help is appreciated.
: >Thanks,
: >Suwat.
: >
: >
Received on Fri Apr 03 1998 - 00:00:00 CST