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 -> Re: Substring search

Re: Substring search

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 08 Dec 2003 20:30:02 +0100
Message-ID: <v7k9tv4f6ue13meepm5a0ps2g3gr60hhtr@4ax.com>


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 DBA
Received on Mon Dec 08 2003 - 13:30:02 CST

Original text of this message

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