Microsoft SQL Server中的星形连接查询优化

Microsoft SQL Server of Star Connection of Query Optimization

该文讨论微软SQLServer在决策支持查询上采取的查询优化和执行策略,方法是基于模式匹配的,检测典型的星型查询模式,当与模式匹配后,优化器生成附加的查询计划方案,显著提高数据仓库的性能。对于高选择性查询,计划使用嵌套循环连接。

This paper discusses the Microsoft SQL Server in decision support inquires the adopted query optimization and implementation strategy, our method is based on pattern matching, detection of typical model, when the star inquires and pattern matching, generate additional query optimizer plan and significantly improve the performance of the data warehouse. For the high selectivity, plans to use query nested circulation connection.