Database Normalization / Read Performance
Kind: tension
Record: tension:database-normalization-read-performance
Canonical: Schema
The canonical schema stays normalized. Read performance comes from derived, denormalized projections rebuilt from it, never from denormalizing the source of truth.
Listed in Tensions, after Principle of Least Surprise / Clever Abstractions and before Security by Design / Developer Ergonomics.