Table B-1 shows the query results of each of the individual queries that were
generated as a result of the DB2 OLAP Server Hybrid Analysis workloads. A
single query in a Hybrid Analysis environment will cause two or more SQL
queries to be generated. It is interesting to see the number of queries generated
for each of the Hybrid Analysis queries and to see where the MQT comes into
play.
TableB-1 lists all of the queries without the use of an MQT and when there was a
drill through query type MQT available.
Table B-1 Detailed query performanc ...
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.