This module explains covering indexes and the INCLUDE clause as well as the use of padding, hints and statistics. The module also covers the use of the Database Engine Tuning Advisor and index-related dynamic management views to assess indexing strategies.
Working with Execution Plans
Using the DTE
Lab: Designing Optimized Index Strategies
After completing this module, you will be able to:
Describe the elements of an execution plan.
Design effective indexing strategies.
Monitor your system to assess the performance of your indexing strategy.