Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
- 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
