What I was told is that you cannot use the LIKE search when you enable case insensitivity in Oracle. I'm not sure how accurate that information is as I was never able to verify that.
So it is likely that indices are ignored as well as indices are usually used for equal to searches. Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. ----- Original Message ---- From: Daniel Bloom <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, December 13, 2006 10:50:35 AM Subject: Q:Oracle 10GR1 case insensitivity Well, let's try again: Is anybody out there using Oracle 10GR1? Is anybody out there using it with case insensitivity? If so, have you had issues with it not using indices? thanks ... Daniel _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________________ Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it now. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
