case insensitive select

  • From: "John Dunn" <jdunn@xxxxxxxxx>
  • To: <Oracle-L@xxxxxxxxxxxxx>
  • Date: Wed, 13 Apr 2005 12:00:31 +0100

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

Other related posts: