What is denormalization and when would you go for it?

Denormalization is the process of attempting to optimize the performance of a database by adding redundant data. As the name indicates, denormalization is the reverse process of normalization. It's the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced