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

When is it acceptable to denormalize?

When measurements show a read path is too slow and an index or query change cannot fix it. Denormalize deliberately, record why, and keep the normalized source of truth so the copy can be rebuilt. Doing it first, without evidence, just adds update anomalies.

Answered in

Relational Schema Design That Survives Contact With Production

Keys, relationships, constraints and indexes: the schema decisions that decide integrity and speed, with worked SQL for one-to-many and many-to-many.

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