Hi,

How to understand execution plan? What are the things need to observe in output ?

Refer the article

http://www.sqlservercentral.com/articles/Performance+Tuning/understandingexecutionplans/739/

-Prashanth

• Proposed as answer by Sofiya LiMicrosoft contingent staff, Moderator 2 hours 7 minutes ago

Hi,

How to understand execution plan? What are the things need to observe in output ?

Hello,

Grant Fritchey has written good book on execution plans please read it

http://download.red-gate.com/ebooks/SQL/sql-server-execution-plans.pdf

Hi Surya.chamala,

According to your description, in SQL Server Management Studio, after the script has been loaded into the Management Studio query editor, and you click the Display Estimated Execution Plan or the Include Actual Execution Plan button. When the script is parsed or executed, you will see a graphical representation of execution plan output in the Execution plan tab.

Usually, nodes will display in the graphical execution plan, including Physical Operation, Logical Operation, Estimated Row Size, Estimated I/O Cost, Estimated CPU Cost and so on, for more information about graphical execution plan node ToolTips, you can review the following article.http://technet.microsoft.com/en-us/library/ms178071(v=sql.105).aspx

There is more detail about an execution plan, you can review the following article.http://www.codeproject.com/Articles/9990/SQL-Tuning-Tutorial-Understanding-a-Database-Execu

Regards,
Sofiya Li

Try the below link, it gives the basic info on execution plans

https://www.simple-talk.com/sql/performance/graphical-execution-plans-for-simple-sql-queries/