they introduce data redundancy (the aggregated data exists both in the base tables and the MQT), but DB2 can maintain them automatically and the optimizer can route queries to them transparently. This provides the performance benefit of denormalization with less risk of data inconsistency than manua