基于SQL Server数据库索引的创建与优化分析

Establishment Based on SQL Server Database Index and Its Analysis

通过建立索引来提升数据库的数据查询和处理速度是数据库最普遍使用的调优方法,如何正确有效的创建和使用索引来提高SQL Server数据库的查询效率是要解决的关键问题。文章首先介绍了索引的相关概念及分类,然后以SQL Server的样本数据库(Northwind)为例,创建和使用聚簇索引和非聚簇索引,进而对建立索引前后的数据库进行查询分析,最后得出了索引创建和使用过程中的若干结论,旨在为SQL Server数据库索引创建和优化工作方面提供一些参考。

For the establishment of the index to enhance the database data query and processing speed, the database tuning methods were commonly used. How to correctly and efficiently create and use the index to im- prove the efficiency of SQL server database query was important to solve the key issues. This paper first introduced the concept and classification of index, and then used sample database （Northwind） as an example to create and used clustered index and non-- clustered index, and then queried and analyzed the database before and after indexing. This paper presented several conclusions in the process of the index creation and use, and provided some references for the creation and optimization of indexes.