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

What are the trade-offs between range-based sharding and hash-based sharding?

Range-based sharding assigns contiguous ranges of keys to shards, making range queries efficient but risking write hotspots if sequential IDs or timestamps are used. Hash-based sharding distributes keys uniformly using hash functions, preventing hotspots but making range scans expensive.

Answered in

Database Sharding Guide: Horizontal Partitioning, Shard Keys, and Cross-Shard Joins

Why databases resist horizontal scaling: deep dive into database sharding, range vs hash vs directory strategies, cross-shard joins, and resharding.

Crashtech Editorial November 15, 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.