SqlServer数据库中聚集索引的用法

Application of Clustered Index in SqlServer Database

随着计算机网络的飞速发展,与数据库相关的系统在越来越多的领域被应用,数据库设计变的越来越重要起来。本文就针对数据库中的聚集索引进行阐述。通过对聚集索引的定义,它与非聚集索引的区别,以及如何选择设置聚集索引等问题,进行了逐一的说明。并列举出在相同的SQL语句下,不同的聚集索引设置,对数据库性能的影响。

With the rapid development of computer networks, database systems in more and more areas are widely applied and database design become more and more important. This article outlines for clustered indexes in the database. Defined by a clustered index, the difference between it and a non - clustered index, as well as issues such as how to select the set clustered index, a description of each. Side - by - side to give in under the same SQL statement, clustered indexes on different settings, effects on the performance of the database.