Multi-Column Distribution for Dedicated SQL pools is now available!

Azure Updates

Discussionpowered by zap.ms

Published

Mar 29, 2023

Status

Launched

Timeline

  • March 2023
    General Availability

Product

Azure Synapse Analytics

Tag

Features

Category

Analytics

Description

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.