In which scenario would denormalization be considered a suitable option for query optimization?

When you want to minimize data redundancy and improve data integrity.
When you want to improve query performance, even at the cost of some data redundancy and update anomalies.
Denormalization is never considered a suitable option for query optimization.
When you want to reduce the size of the database.

Denormalization is considered when you want to optimize read-heavy queries and reduce the number of JOIN operations. It involves introducing redundancy to improve query performance, but it can lead to data anomalies.

Add your answer