What is the primary objective of denormalization in DB2?

To enforce referential integrity
To increase redundancy and simplify data retrieval
To optimize storage space
To reduce redundancy and improve query performance

Denormalization in DB2 is primarily aimed at reducing redundancy in the database schema. This helps in improving query performance by minimizing the need for joining multiple tables. By eliminating or reducing the number of joins, denormalization speeds up data retrieval operations, especially for complex queries involving multiple tables.

Add your answer