What is denormalization? When is it the right choice and what does it cost?

Answer preview

Denormalization is deliberately storing redundant or pre-computed data — a copied column, a rollup total, a materialized view — so a hot read path avoids joins and aggregation. It trades write cost and consistency risk for read latency, and it is only justified once you have a me…