Get the SQL Server Execution Plan Guide

This PDF guide contains:

• a list of the common access methods, join operations, and sort operations that you see in an SQL Server Execution Plan
• a definition of each term
• an explanation of when they would be used

Use this list to understand what the Execution Plan or Explain Plan is showing you and as a first step to improving your query performance.