Wednesday, July 1, 2015

JDBC query with bind variables can have performance issue

It seems like I am on a performance kick after finding this note on My Oracle Support "Poor Performance With Query Called From JDBC Using Bind Variables Compared To A DATE Column" from document ID 1557194.1 which teaches us about the reasons a JDBC query might not use the best access path/plan based on what kind of DATE or TIMESTAMP variables you use.

No comments:

Post a Comment