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

Why are cross-shard joins considered an anti-pattern in sharded architectures?

Executing a SQL join across multiple independent database nodes requires the application tier to coordinate distributed queries, stream intermediate table rows across the network, and perform in-memory joins, severely degrading query latency.

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.