Further reading
Note that just like Power BI, every area of Synapse benefits from specific performance tuning guidance. The following are some references to the relevant performance guidance material:
- Serverless SQL pool best practices: https://docs.microsoft.com/azure/synapse-analytics/sql/best-practices-serverless-sql-pool
- Dedicated SQL pool best practices: https://docs.microsoft.com/azure/synapse-analytics/sql/best-practices-dedicated-sql-pool
- Azure Advisor recommendations for dedicated SQL pools: https://docs.microsoft.com/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-recommendations
- Materialized view optimization: https://docs.microsoft.com/azure/synapse-analytics/sql/develop-materialized-view-performance-tuning
- Clustered index optimization: https://docs.microsoft.com/azure/synapse-analytics/sql-data-warehouse/performance-tuning-ordered-cci
- Result set cache optimization: https://docs.microsoft.com/azure/synapse-analytics/sql...
