At 09:32 AM 4/3/2007, Don Seiler wrote:
Alright this gets even more confusing (to me anyway). I looked in v$sql_bind_capture to see what the datatypes were. When he was running via his java app, it was actually using the right datatypes, 3 varchar2 and 2 numbers. However, looking at my tests from Oracle SQL Developer, it actually passes in all varchar2(32) types, and uses the index. Pretty counterintuitive.
That suggests that there is a type mismatch somewhere which prevents the optimizer from using the index.
Regards Wolfgang Breitling Centrex Consulting Corporationwww.centrexcc.com
______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System.For more information please visit http://www.messagelabs.com/email ______________________________________________________________________