Re: Substring search

> Hi,
> Is there any way to perform a substring search without full table scan
> (Oracle 8.1.7) and make it a little bit effective? I know that Oracle
> doesn't use index in search of the form:
> select * from table where column like '%substring%';
> but maybe there are some tricks to speed up queries like this
>
> Thanks for any answers
> szalas

Szalas,

I have an article on my web page adressing this problem that you might find useful:

  http://www.adp-gmbh.ch/ora/plsql/poor_mans_text_index.html  

hth,
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch