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

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".

• Steve