Distributed tables design guidance - Azure Synapse Analytics
Recommendations for designing hash-distributed and round-robin distributed tables using dedicated SQL pool.
Has many unique values.
Does not have NULLs, or has only a few NULLs.
Is not a date column
Is not used in WHERE clauses.
Is used in JOIN, GROUP BY, DISTINCT, OVER, and HAVING clauses.