Summary
You have just learned how to optimize querying performance on Azure Synapse Analytics SQL Pools for use in analytical workloads.
In this module, you have:
- Understood Performance Issues Related to Tables
- Understood Table Distribution Design
- Used Indexes to Improve Query Performance
- Created Statistics to Improve Query Performance
- Improved Query Performance with Materialized Views
- Used Read Committed Snapshot for Data Consistency
- Optimized Common Queries with Result-Set Caching