Denormalization

Difficulty: Intermediate

Question

When is denormalization a good idea?

Answer

In read-heavy applications where complex joins are causing performance issues. It purposefully adds redundancy to speed up data retrieval.

Concepts covered

Performance, Read-heavy, Redundancy