RE: explain plan and the real execution plan
Date: Tue, 17 Nov 2009 11:16:30 -0800
Message-ID: <EB9DFB3B8215BD428634CD68162F55B60510A031_at_SNV-EXVS06.ds.corp.yahoo.com>
Thank you all for the examples. I am convinced.
Lei
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Allen, Brandon
Sent: Tuesday, November 17, 2009 9:26 AM
To: Lei Zeng; oracle-l_at_freelists.org
Subject: RE: explain plan and the real execution plan
Here's an example from Tom Kyte:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5035 12000346581816
Regards,
Brandon
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lei Zeng
The implicit data type conversion
Would you provide a testing case on this?
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 17 2009 - 13:16:30 CST