Doing an explain without the MQTs yields the situation shown in Figure 4-26.
Figure 4-26 The top five most profitable consumer groups without MQTs
As can be seen in Figure 4-26, the cost of running the query without the query
rewrite is 766,026.56 timerons.
Now, in Figure 4-27, we try the same query on the same data, but with the MQTs
in place.
Chapter 4. Using the cube model for summary tables optimization 191
Figure 4-27 The top five most profitable consumer groups with MQTs
Figure4-27 tells us that the cost of the ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.