🧭Denormalization
Also known as Denormalisation, Denormalized Table
The same data is copied into one wide table. Reads get much faster.
Think of it like
It is like writing a friend's phone number in each book you own. It takes more ink, but you find it fast.
Example
An orders table also keeps the buyer's city and the product name. A report of sales by city then needs no joins.
Why it matters
Most analytics tables are denormalized. It is the main trick that makes big reports fast.
Definition
Common mistake
Key takeaways
- 1Copy on purpose. The same fact sits in many rows.
- 2Fewer joins. One wide table answers the question.
- 3Harder to update. Every copy must change together.