SQL Server数据库查询优化技术应用

Study on Query Optimization for SQL Server Database

在结构化查询语言中,SELECT是一个关键的查询操作语句。为了设计合理高效的查询脚本,应合理使用索引、嵌套子查询、WHERE条件子句。从SQL Server数据库查询优化方法的各个方面描述该技术的应用,最后能正确评价各种方法的优点及代价,从而选出最佳方案。

SELECT is a key statement of query operation in structured query language （SQL）. In order to design a high effective and reasonable query script, index, subquery, WHERE condition phrases in SELECT statement should be reasonably used. The application of technology is described from the different sides of SQL server database query optimization method, which can correctly evaluate the advantages and costs of different methods so as to select the optimize program.