While using Azure Synapse Analytics dedicated SQL pools, sometimes it is confusing the purpose of partitioning and distribution. They are both used to manage data for performance optimization, but serve different purposes.
Distribution
Distribution r...