Re: Interpreting the execution plan results

Kenny M. (KennyM@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
> On Query Analyzer..
>
> I can figure out a little what the information on the execution plan means
> but I'm not sure
>
> Where can I find a good description about each item that is show in the
> execution plan?
>
>
> e.g estimated subtree cost etc..

SQL Server Books Online. Optimizing Database Performance->Query Tuning->
Analyzing a Query->Logical and Physical Operators.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Timeout during initial basic insert
    ... have you looked at the execution plan in Query Analyzer to find out ... Is this a problem with SQL server? ...
    (microsoft.public.sqlserver.server)
  • Re: query performance help needed
    ... Whether the execution plan is there or not has little do with it. ... It's very clear that you need to analyse your query plans, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: query plan in clear text
    ... Personally, I do almost all tasks from Query Analyzer, and about the only ... Enterprise Manager is to deal with jobs. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Database Engine Tuning Advisor suggestion to replace syntax.
    ... What you said was what I first planned to say, but then I read the Books Online which implies that the batch is indeed reused, so I held back from saying that. ... the query optimizer will probably match the Transact-SQL statement in the second execution with the execution plan generated for the first execution. ... SQL Server does not have to compile the second statement." ...
    (microsoft.public.sqlserver.tools)
  • Re: Execution Plan in Query Analyzer
    ... GRAPHICAL EXECUTION PLAN - MS SQL Server Management Studio: ... >> I thing, problem is in Query Analyzer, but how correct this? ...
    (microsoft.public.sqlserver.tools)