SQL Server查询优化技术分析与实现

Technology and Implementation of Query Optimization in SQL Server

使用数据库的主要目的是方便快捷地使用数据,数据库中所有操作都离不开查询。查询处理是SQL Server产品中非常重要的组成部分,在查询处理中,最复杂且重要的是查询的优化技术。该文分析了多阶段优化,并重点讨论优化查询策略在子查询中具体实现。

The main purpose of using the database is to use the data conveniently,all operations of the database cannot do with out query.Query processing is a very important part of SQL Server products,in the query,the most complex and important is to optimize the technology of query.This paper analyzes the multi-stage optimization,and focuses on query optimization strategy implementation in a subquery.