聚集和非聚集索引的差异 [英] Diffrance of Clustered And Nonclustered Index

问题描述

任何人都可以告诉我有关聚簇和非聚簇索引的真实示例.

Can Anyone tell me real life example on Clustered And Nonclustered Index.

Thanks.

推荐答案

聚集索引是一种特殊的索引类型，它重新排序表中记录的物理存储方式. 因此，表只能有一个聚集索引，并且该聚集索引通常是在主键上进行的.聚簇索引的叶节点包含数据页.

非聚集索引是一种特殊类型的索引，其中索引的逻辑顺序与磁盘上行的物理存储顺序不匹配.非聚集索引的叶节点不包含数据页.相反，叶节点包含索引行.
每个表最多可以有249个非聚簇索引

请参考 http://www.sql-server-performance.com/2004/index-data-结构/ [^ ]

A clustered index is a special type of index that reorders the way records in the table are physically stored.
Therefore table can have only one clustered index and this is usually made on the primary key. The leaf nodes of a clustered index contain the data pages.

A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.
There can be as many as 249 nonclustered index per table

Refer http://www.sql-server-performance.com/2004/index-data-structures/[^]

这篇关于聚集和非聚集索引的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！