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 -> Best way to search a large VARCHAR2 column

Best way to search a large VARCHAR2 column

From: Suwat Phruksawan <sphruksa_at_earthlink.net>
Date: 1998/03/26
Message-ID: <6ffm47$6rg@argentina.earthlink.net>#1/1 







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 Thu Mar 26 1998 - 00:00:00 CST












Original text of this message













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