Re: SQL Command

From: <bsc7080mqc_at_mylxhq.com>
Date: Tue, 25 Mar 2003 06:48:25 -0500
Message-ID: <ybXfa.7928$yO.1970@fe02.atl2.webusenet.com>

What if you created a function index that did a substring of the last xxx characters and then ran your query with a substring command instead ? Or maybe consider a context type of index (i think it is called that) which is commonly used for parsing XML strings and such.

BChase
MylxHQ - Oracle Resource Portal
http://oracle.mylxhq.com

On Tue, 25 Mar 2003 09:27:03 +0100, "Stephan Bressler" <stephan.bressler_at_siemens.com> wrote:

>
>"Tanel Poder" <tanel@@peldik.com> wrote in message
>news:3e7f715e$1_2_at_news.estpak.ee...
>> > SELECT description
>> > FROM stock
>> > WHERE UPPER(description) LIKE '%APPLES%'; or
>> >
>> > SELECT description
>> > FROM stock
>> > WHERE LOWER(description) LIKE '%apples%';
>>
>> Note that this kind of query isn't able to use any normal indexes on
>column
>> description if you don't create function based indexes on UPPER or LOWER
>> function.
>True, but if the pattern starts with %, an index won't help anyway.
>Stephan
>
Received on Tue Mar 25 2003 - 05:48:25 CST