Sharding Key Design

Choose partition keys that minimize cross-shard transactions while avoiding query distribution bottlenecks.