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: Nuno Guerreiro <nuno-v-guerreiro_at_telecom.pt>
Date: 1998/03/31
Message-ID: <3523c3a1.63784967@news.telecom.pt>#1/1

On Thu, 26 Mar 1998 23:52:21 -0000, "Suwat Phruksawan" <sphruksa_at_earthlink.net> wrote:

>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.
>
>

Sorry, I placed a reply instead of a New Post. Received on Tue Mar 31 1998 - 00:00:00 CST

Original text of this message

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