← recall

partition key term

field used to assign rows to a partition

Most important schema decision in a sharded system. Hard to change later. Bad keys cause hot partitions, hot tenants, inability to scale.

aliases: shard key, hash key

topics: partitioning, databases

references:

• DynamoDB — Choosing a partition key