Chapter 13. Accessing DB2 dimensional data using MicroStrategy 603
When submitting the same SQL from Regional Department Sales Contribution
report into a DB2 Database with Cube Views and MQTs enabled the Database
was able to determine the usage of MQT tables dynamically and used them as
fact tables for the resolution of the results.
The database cost for solving this SQL was 3,779.44 timerons with a more
simplified construction complexity. The results are shown in Figure 13-9.
Figure 13-9 DB2 explain for question 1: with MQT
Table 13-2 summarizes the data access path costs issued from DB2 explain
when using DB2 Cube Views MQTs.
Table 13-2 Query performance result
Without MQT 735,263.62
With MQT 3,779.44