On 04/13/2005 07:00:31 AM, John Dunn wrote: > 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. >=20 > Any other way to do it? Yes. You can try with to_lower or read about function-based indexes. That's a classic example of what they're used for.=20 --=20 Mladen Gogala Oracle DBA -- //www.freelists.org/webpage/oracle-l