Execution plan output

Hi All,
I am having trouble understanding the output of the query execution plan.
Any document that explains the terms used in the output of the query
execution plan would help me understand and identify areas for improvement
in the SQL query.
Any pointers to such documents or any of your homegrown ideas to decipher
the information would be highly appreciated.
Thanks.
Regards,
SoumitraThis article has an intro:
http://www.sql-server-performance.com/mr_indexing.asp
"Soumitra Banerjee" <sbanerjee@.epacesoftware.com> wrote in message
news:uBzRMRBcEHA.1408@.TK2MSFTNGP12.phx.gbl...
> Hi All,
> I am having trouble understanding the output of the query execution plan.
> Any document that explains the terms used in the output of the query
> execution plan would help me understand and identify areas for improvement
> in the SQL query.
> Any pointers to such documents or any of your homegrown ideas to decipher
> the information would be highly appreciated.
> Thanks.
> Regards,
> Soumitra
>
>|||Look up Graphical Showplan in Books Online. It gives an explanation for
each of the operations. You might also want to try our freeware product,
Query Analyzer Tool, that displays the execution plan in a treeview (which
allows you to see 'more' in a screen) and highlights the top 5 most
expensive operations, and also allows you to save the plans for future
analysis.
Peter Yeoh
http://www.yohz.com
Earn free licenses for MiniSQLBackup. Details on website.
"Soumitra Banerjee" <sbanerjee@.epacesoftware.com> wrote in message
news:uBzRMRBcEHA.1408@.TK2MSFTNGP12.phx.gbl...
> Hi All,
> I am having trouble understanding the output of the query execution plan.
> Any document that explains the terms used in the output of the query
> execution plan would help me understand and identify areas for improvement
> in the SQL query.
> Any pointers to such documents or any of your homegrown ideas to decipher
> the information would be highly appreciated.
> Thanks.
> Regards,
> Soumitra
>
>