A costestimation that assumes normal data distribution may not best reflect the real cost of a query when different parameters are used.
假定正常数据分布的开销评估可能并不能最好地反映查询使用不同参数时的实际开销。
2
For each predicate in the query, query Tuner adds statistics annotations for the referenced columns in the predicate and also the costestimation for the predicate.
对于查询中的每个谓词,Query Tuner为谓词中的引用行和谓词的成本评估添加了统计数据注释。
3
In the integration server layer, design a query optimizer and research query rewrite, costestimation model and caches mechanism.