SQL Server Exceution plan

• sqlservering

  SSC Veteran

  Points: 222

  More actions

  July 23, 2008 at 4:36 am

  #123356

  Hi Friends,

  Am very much new to sql server, I came across sqlexecution plan. What does this do?

  I found a select box, and a bax named clustered index scan..

  what does all these signify??

  If some one could help me understand them, in layman terms

  thanks..

• Deepak-405225

  SSCertifiable

  Points: 6120

  More actions

  July 23, 2008 at 4:55 am

  #846904

  Brad has written a nice article about it. Please refer, http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx

  If you wish to know more, you can get this book on performance tuning Sql 2005 http://www.amazon.com/Inside-Microsoft%C2%AE-SQL-Server-2005/dp/0735621969

  [font="Verdana"]- Deepak[/font]