Re: Oracle not liking the index ... sometimes

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 Corporation
www.centrexcc.com 


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: