| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> 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
Received on Mon Dec 08 2003 - 12:40:43 CST
 |
 |