Optimize query performance in Azure SQL

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

After completing this module, you will be able to:

• Explore Dynamic Manage Objects to extract query performance information
• Determine when changing indexes or defining new ones can affect performance
• Evaluate wait statistics as an aid in finding areas for performance improvement

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
• Investigate the value of data compression