Re: Experts plese help me..

From: Lars Lerager <lerager_at_get2net.dk>
Date: Fri, 19 Nov 1999 03:44:43 +0100
Message-ID: <yN2Z3.55$B4.3860@news010.image.dk>

"paul cluiss" <paul_cluiss_at_intervoice.com> wrote in message [CUT]
>
> If these assumptions are correct, I propose this SQL statement:
>
> select * from the_table where the_column like '%CP%';
>

[CUT] Consider this:
If "the_coloumn" is an indexed coloumn you should avoid wildcards (%) in the start of the LIKE 'xxxx'-statement. These wildcards prevents Oracle from using the index. If possible - do like this:

select * from the_table where the_column like 'CP%';

Lars Received on Thu Nov 18 1999 - 20:44:43 CST