Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Does Autotrace give the actual execution plan?

Re: Does Autotrace give the actual execution plan?

From: Banavara <rbanavara_at_gmail.com>
Date: 6 Jul 2006 13:59:55 -0700
Message-ID: <1152219595.272889.115340@s53g2000cws.googlegroups.com> 





hmm thought plan from autotrace (from SQL*Plus) was the actual plan
used by the query...  and will be same unless the stats change...



-rbanavara



> Sorry no autotrace will not necessarily show you the plan that was used

> for the SQL.  It will show you a plan.  That plan may or may not be

> what the query will actually use ... if often is correct but not always.

Received on Thu Jul 06 2006 - 15:59:55 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US