How does denormalization impact query performance in DB2?
- Decreases query performance
- Has no impact on query performance
- Increases query performance by increasing joins
- Increases query performance by reducing joins
Denormalization increases query performance by reducing the number of joins required to retrieve data. By storing redundant data, it eliminates the need for joins, thus improving performance.
Loading...
Related Quiz
- Which aggregation function in DB2 is used to calculate the variance of a set of values?
- What is a full database backup in DB2?
- What is the purpose of partitioning a table in DB2?
- Log shipping in disaster recovery involves periodically copying ________ from the primary to the standby server.
- Describe the process of auditing in DB2 and its importance in ensuring security.