浅析SQL Server 2000中索引对查询性能的影响

Analysing the effect of the index upon query capability on SQL Sever 2000

本文通过说明SQL Server2000中查询优化器的工作原理,介绍了查询优化器如何针对不同的查询语句和索引进行优化,并给出了针对数据库表如何设计索引和编写性能优化的查询的一般规律。

In this paper by explaining the principles of query optimizer, we Introduce how to optimize the different query statement and index . In the end we give the disciplinarians about designing index and programing optimized query.