can anyone explain how to read a execution plan in SQL Server With Example Please?
+2
A:
SQL Server graphical execution plans in action
In this article, I identify a few basic things to look for in a graphical execution plan to help you better understand how SQL Server uses indexes. I also offer ideas about how to make your queries faster.
Understanding Execution Plans (registration required)
The purpose of this article is to give you a working knowledge of how to view and understand query execution plans for SQL Server.
Rex M
2009-04-17 03:39:51
Thank you very much
Anoop
2009-04-17 04:03:51
A:
You should also check out Simple-Talk - a neat programming web site on .NET and SQL.
They have excellent articles on many topics, including query plans:
- Execution plan basics
- Graphical execution plans for simple queries
- Understanding more complex query plans
Highly recommended!
Marc
marc_s
2009-04-17 05:05:44
You can download the book from here:http://downloads.red-gate.com/ebooks/HighPerformanceSQL_ebook.zip
Joakim Backman
2009-04-17 06:27:53