Re: Does Autotrace give the actual execution plan?

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.

.

Relevant Pages

  • Re: SP runs slower than same query in Query analyzer. Why??
    ... Andrew your reply was useful but I'm quite new to sql server and I'm ... query gives me the results in 3-4 seconds. ... > Keep in mind that the server has to compile a complete execution plan ... > when compiling a plan. ...
    (microsoft.public.sqlserver.clients)
  • Re: Execute SQL UD Function call timeout, 1-3 seconds in query ana
    ... We did build a little ASP.NET page yesterday that lets us put a given sql ... query into a text box and then return the execution plan (using Showplan_Text ... Query Analyzer. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Performance problem
    ... Why CPU time is 28 seconds if query executes in 2 seconds? ... Links for SQL Server Books Online: ... I have one query which executes immediatelly with hint OPTION(FORCE ... otherwise it executes many seconds(wrong execution plan). ...
    (microsoft.public.sqlserver.programming)
  • Composite index and data distribution
    ... SQL> create table foobar ... COMPOSITE INDEX (BEST I CAN THINK OF FOR THE QUERY TO BE EXECUTED): ... Execution Plan ... 395 bytes received via SQL*Net from client ...
    (comp.databases.oracle.server)
  • Re: Store procedure vs Direct statement ???
    ... Try opening up query analyzer and checking out the query plan or ... advantages of using stored procedures over not using stored procedures is the ... the better the overall performance of your SQL ... dynamic sql versus the execution plan for a stored procedure. ...
    (microsoft.public.dotnet.framework.adonet)