Re: Oracle not liking the index ... sometimes

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 03 Apr 2007 11:35:14 -0600
Message-Id: <20070403173352.DECAD6985C8@turing.freelists.org>

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

Received on Tue Apr 03 2007 - 12:35:14 CDT