You could develop a data cartridge and a custom index type to perform
substring searches
(this has probably been done before, search the web)
"szalas" <gszalach_at_hotmail.com> wrote in message
news:br2cvv$r8v$1_at_julia.coi.pw.edu.pl...
> 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
>
>
Received on Tue Dec 09 2003 - 14:58:21 CST
