RE: Different Plans for Literal Vs Bind Variables
Date: Tue, 13 Jan 2009 12:55:58 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E10A3413EE3_at_ONEWS06.oneneck.corp>
Nice test case Alberto. The whole thing seems familiar to me too - I have a feeling if/when we get to bottom of this it will be a "Doh!" moment. I wonder if Jonathan Lewis visits this list anymore - I bet he'd know the answer but I don't recall seeing his name pop up here for a while.
Ian, it would be interesting to see your results from running Alberto's test case against your database.
Regards,
Brandon
-----Original Message-----
From: Alberto Dell'Era [mailto:alberto.dellera_at_gmail.com]
I think Ian might want to try 10.2.0.4; the following test case shows that the CBO, in that version, does seem to peek for the binds "through" a date function
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. †Ûiÿü0ÁúÞzX¬¶Ê+ƒü n– {ú+iÉ^ Received on Tue Jan 13 2009 - 13:55:58 CST