Microsoft SQL Server of Star Connection of Query Optimization
Xiaoyu Ma · Coal Technology · 2011
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.