Main Content

Execution Plan Basics

About the Talk

January 29, 2011 3:40 AM

Bammel Church of Christ, 2700 FM 1960 West, Houston, TX 77068

Bammel Church of Christ, 2700 FM 1960 West, Houston, TX 77068

This will be a Beginner to Intermediate session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?

Ratings and Recommendations

Avg. Rating

Average based
on 2 ratings

comments powered by Disqus