Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Substring search
On Mon, 8 Dec 2003 19:40:43 +0100, "szalas" <gszalach_at_hotmail.com>
wrote:
>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
>
Other than using Oracle Context (or Oracle Intermedia) there are no 'tricks'. Those 'tricks' would also go against logical reasoning.
-- Sybrand Bakker, Senior Oracle DBAReceived on Mon Dec 08 2003 - 13:30:02 CST
![]() |
![]() |