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

Other related posts: