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

Why do joins get harder after sharding?

A join across two tables works efficiently when both tables live on the same machine. Once data is split across shards, a join between rows that ended up on different shards requires fetching data from multiple machines and combining it in application code or a query-federation layer — there's no single SQL query that can do it as elegantly as an unsharded join could.

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.