Problem Statement
When would you denormalize an OLTP schema and what risks come with it?
Explanation
Denormalize when read latency and complex joins dominate critical paths, or when pre-joined aggregates are repeatedly needed. It trims joins and can simplify queries.
Risks include write amplification, anomalies, and harder integrity. You must add repair jobs, careful update paths, and validations to keep copies in sync.
