SQL Server Execution Plans. This presentation covers the following topics :
- Display Estimated Execution Plan
- Include Actual Execution Plan
- SET SHOWPLAN_TEXT ON / OFF
- SET SHOWPLAN_ALL ON / OFF
- Different Access Paths
For more presentations regarding this subject, use this link.