Re: Does Autotrace give the actual execution plan?

Banavara wrote:
> 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.

.gnitsop
pot
pots
esaelp

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org