Forum Discussion
AbuasRinroe
May 21, 2025Copper Contributor
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