Discuss the trade-offs involved in denormalization with respect to data redundancy and query performance.

Denormalization involves increasing redundancy by storing redundant data to improve query performance. However, this can lead to potential data inconsistency issues if the redundant data is not properly maintained. While denormalization can enhance query performance by reducing the need for joins, it comes at the cost of increased storage space and the risk of data anomalies. Thus, the trade-offs of denormalization include balancing data redundancy for improved query performance.