10G Case Insensitive Searches.

From: LineVoltageHalogen <tropicalfruitdrops_at_yahoo.com>
Date: 30 Jun 2005 10:09:05 -0700
Message-ID: <1120151345.531877.104800@z14g2000cwz.googlegroups.com>

If I understand correctly by setting the following:

alter session set nls_comp=ansi;

alter session set nls_sort=binary_ci;

I can issue a query against the database that is case insensitive. My question is this: When I test this functionality the index I have in place is not longer used for the query? Do I need to create a special function based index to speed things up or should the existing index (which works if I don't specify the alter sessions) work?

TFD Received on Thu Jun 30 2005 - 12:09:05 CDT