| 1. | Application of mqt series penumatic jumbolter
钻机的应用 |
| 2. | Cube server periodically pulls data from mqts and fact tables
Cube server定期从mqt和事实表中提取数据。 |
| 3. | Mqt defined on tab3
Tab3上定义的mqt |
| 4. | Note that you may need to modify the mqt script to specify proper partition key
注意您可能需要修改mqt脚本以指定正确的分区关键字。 |
| 5. | The mqts generated by cube views can significantly improve performance of olap queries
Cube views生成的mqt可以显著提高olap查询的性能。 |
| 6. | As the mqt is created , use visual explain to see if db2 reroutes the following sample query to mqt
创建了mqt后，使用visual explain查看db2是否将下列示例查询改为发送到mqt ： |
| 7. | And since mqts tend to be much smaller than the base tables , response time of olap queries can improve significantly when the queries are rerouted to the mqts
而且因为mqt往往比基础表小很多，所以当查询改为发送到mqt时， olap查询的响应时间可以显著改善。 |
| 8. | Since summary data is precomputed in the mqts , db2 optimizer may rewrite a specific query to access an mqt instead of based tables because the optimizer can recognize if result sets can be derived from an mqt with less predicted cost
因为汇总数据在mqt中预先计算，所以db2优化器可以改写特定查询来访问mqt ，而不是基础表，因为优化器可以识别是否能以较少的预计成本从mqt得到结果集。 |
