What is denormalization?

Denormalization intentionally introduces redundancy or precomputed data to improve read performance or simplify specific access patterns.

Examples include storing summary totals, maintaining reporting tables, or duplicating descriptive data in a warehouse. Denormalization can improve read-heavy workloads but creates additional consistency and update complexity.

It should be based on measured requirements rather than used as a substitute for proper indexing or query optimization.