RE: explain plan and the real execution plan

From: Lei Zeng <lzeng_at_yahoo-inc.com>
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-l
Received on Tue Nov 17 2009 - 13:16:30 CST

Original text of this message