RE: case insensitive select

From: Amihay Gonen <AmihayG_at_ectel.com>
Date: Wed, 13 Apr 2005 14:11:39 +0300
Message-ID: <A18EEF7322197F4A8586D0B013C7B8F60587801C@ectexil1.ectel.com>

Upgrade to 10g .
alter session set nls_sort=binary_ci;

Refer to
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:163706754 23662

-----Original Message-----

From: John Dunn [mailto:jdunn_at_sefas.com] Sent: Wednesday, April 13, 2005 2:01 PM
To: Oracle-L_at_freelists.org
Subject: case insensitive select

I am doing a slect on 15 million rows of data. I want to do a case insensitive serach, but using the TO_UPPER clause just slows performance dramatically.

Any other way to do it?

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 13 2005 - 07:12:36 CDT