索引优化设计及性能评测

Index Design Optimization and Performance Evaluating

数据查询的效率是影响数据库应用系统整体性能的其中一项重要指标。本文着重探讨了索引在优化数据库系统性能方面的作用及具体的实现原则,并通过对查询语句效率的对比,介绍了在SQL Server中的查询语句性能测定的方法。

The efficiency of data query is one of important target to performance of DBS. This article discusses the action of index in optimizing DBS performance and idiographic implement principia, and introduce the method in determining query performance by contrast different query sentence in SQL Server.