Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
- Explore query performance optimization
After completing this module, you will be able to:
- Generate and save execution plans
- Compare the different types of execution plans
- Understand how and why query plans are generated
- Explain the purpose and benefits of the Query Store
- Investigate the available reports and data in the Query Store
- Explore performance-based database design
After completing this module, you will be able to:
- Explore normal forms and how they affect database design
- Choose appropriate datatypes for your data
- Evaluate appropriate index types
- Evaluate performance improvements
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
