mqt 中文意思是什麼
mqt
解釋
多量子躍遷-
Application of mqt series penumatic jumbolter
鉆機的應用 -
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得到結果集。 -
Mqt defined on tab3
Tab3上定義的mqt -
Note that you may need to modify the mqt script to specify proper partition key
注意您可能需要修改mqt腳本以指定正確的分區關鍵字。 -
As the mqt is created, use visual explain to see if db2 reroutes the following sample query to mqt
創建了mqt后,使用visual explain查看db2是否將下列示例查詢改為發送到mqt :
分享友人