Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g2 LIKE operator and case-insensitive issues

Re: Oracle 10g2 LIKE operator and case-insensitive issues

From: Steve Chien <stevechien_at_wisagetech.com>
Date: Sat, 12 May 2007 08:48:54 +0800
Message-ID: <tj3a431tu1p0sfqd36uuo3crtqndpld1eq@4ax.com>


On 11 May 2007 07:57:12 -0700, Gints Plivna <gints.plivna_at_gmail.com> wrote:

>Steve Chien wrote:
>> Hi,
>>
>> We're curerrently facing some performance issues related to the
>> "LIKE" operator in Oracle 10g2. Here is what we encountered.
>
>Hmmm and the reason just not to use function based index is?...
>
>Gints Plivna
>http://www.gplivna.eu

  We used the nlssort to create the indexes. Actually, it's function-based index. When you have NLS parameters set properly, the Oracle can rewrite your query and use it as needed.

  It did work with the "=", but not the "LIKE".

Received on Fri May 11 2007 - 19:48:54 CDT

Original text of this message

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