Interpreting the execution plan results

microsoft.public.sqlserver.tools

1 Dec 2005 6:48 PM

Kenny M.

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..

thks

4 Dec 2005 10:43 PM

Erland Sommarskog

Kenny M. (Ken***@discussions.microsoft.com) 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, esq***@sommarskog.se

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