...为要么优化器会自动重写 GROUP BY 语句来分离 GROUP BY 操作并消除排序, 要么您可以构造自动总结表(automatic summary table,AST),这种表可以消除排序。对于所有的大型主机(mainframe),您需要考虑重写自己的查询。
基于2个网页-相关网页
可以通过定义物化查询表(Materialized Query Tables, MQT)——以前称为自动总结表(Automatic Summary Tables, AST)——来在本地缓存引用关系和非关系昵称的查询的结果。
Materialized Query Tables (MQTs), formerly known as Automatic Summary Tables (ASTs), can be defined to locally cache the result of queries that reference relational and non-relational nicknames.
研究和实现了图论中无向图的简单路径查找算法,对连锁表的编制规则进行了总结,实现了相应的联锁表自动生成算法。
Based on the research of the rules to compose the interlocking table and simple path search of graph, we design an algorithm to generate the interlocking table from signal arrangement.
应用推荐