There are different ways you can get your SQL Pools to run faster in Azure Synapse Analytics. Patrick looks at a feature that can really take it to the next level! You seriously need to watch this if you are using Synapse dedicated SQL Pools.
Performance tuning with materialized views using dedicated SQL pool in Azure Synapse Analytics
https://docs.microsoft.com/azure/synapse-analytics/sql/develop-materialized-view-performance-tuning