Summary
Azure SQL has included many features in recent releases to improve performance. Many of these features can be enabled at the individual database level, and may also be controlled using the compatibility level of the database.
Maintaining indexes and statistics can help provide consistent performance for your queries. Additionally, Azure SQL Database automates the creation of new indexes and the removal of unused indexes.
Now that you've reviewed this module, you should be able to:
Understand database scoped configuration options
Understand maintenance tasks related to indexing and statistics
Understand the features of Intelligent Query Processing
Explore the automatic tuning feature in Azure