---
answer: direct
beat: system-design
source: 1 article · updated: November 17, 2026
---

How do you pick a good shard key?

A good shard key distributes data and traffic evenly across shards (avoiding hotspots), keeps data that's frequently queried or joined together on the same shard (minimizing cross-shard operations), and rarely needs to change after being set — because resharding live data is one of the most disruptive operations a database system can undergo.

Answered in

Database Sharding: What It Actually Costs When You Split the Database

Sharding scales a database past one machine's limits, but it changes joins, transactions, and query patterns. Here's what each strategy trades away.

Crashtech Editorial November 17, 2026 System Design & Architecture

Read the full analysis

Other questions this article answers

More system design & architecture questions

Every answer on Crashtech is written by the editor of the article it comes from — never auto-summarised. Browse all answers or the System Design & Architecture beat.