Multi-Column Distribution for Dedicated SQL pools is now available!
Published date: 29 March, 2023
Multi-Column Distribution (MCD) for Azure Synapse Dedicated SQL pools allows you to distribute data on multiple columns to balance the data distribution in your tables and reduce data movement during query execution. With Multi-Column distribution, you can choose up to eight columns for distribution. MCD is highly desirable for easing migrations, promotes faster query performance and reduces data skew.
To learn more, see CREATE TABLE, CREATE TABLE AS SELECT and CREATE MATERIALIZED VIEW.