Evaluate possible changes to indexes. Determine the impact of changes to queries and indexes. Explore Query Store hints.
After completing this module, you will be able to:
- Determine when changing indexes or defining new ones can affect performance
- Evaluate wait statistics as an aid in finding areas for performance improvement
- Understand how query hints work, and when to use them