Forum Discussion

AbuasRinroe's avatar
AbuasRinroe
Copper Contributor
May 21, 2025

Partitioning in Azure Synapse

Hello,

Im currently working on an optimization project, which as led me down a rabbithole of technical differences between the regular MSSQL and the dedicated SQL pool that is Azure PDW.

I noticed, that when checking the distributions of partitions, when creating a table, for lets say splitting data by YEAR([datefield]) with ranges for each year '20230101','20240101' etc, the sys partitions view claims that all partitions have equal amount of rows. Also from the query plans, i can not see any impact in the way the query is executed, even though partition elimination should be the first move, when querying with Where [datefield] = '20230505'. 

Any info and advice would be greatly appreciated. 

No RepliesBe the first to reply

Resources