SQL server数据库中查询的优化技巧

查询是数据库中最基本、最常用、最复杂的操作。而有的查询语句要花较长时间才能返回结果，速度极其缓慢，用户无法忍受。本文从索引、提示和查询执行计划等角度来讨论查询优化技巧，希望能给大家带来一些帮助。

Optimizing Enquiring Skills in the SQL Server Database

Enquiry is the most basic, complicated and frequently used operation in the database. To enquiry some sentences , it will take very long time to get the result. The inquiring speed is very slow and it can not be tolerated by users to some extent . This paper discussed the optimized skills of enquiry from the perspectives of index ,hints and enquiring executive plan . The purpose is to give readers some help in their enquiring work .