good partition column

1. functional identifier
2. high cardinality (lot of distinct values)

Role

Clustering column(s)

Simulate 1-N relationship

sort data (logically and on disk)