clustered 和 unclustered index的区别

最新推荐文章于 2024-11-25 18:27:31 发布

BoBoAn_DouYa

最新推荐文章于 2024-11-25 18:27:31 发布

阅读量2.3k

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库

本文链接：https://blog.csdn.net/chengy35/article/details/14524405

数据库专栏收录该内容

8 篇文章

订阅专栏

本文深入探讨了SQL数据库中簇集索引与非簇集索引的区别，解释了它们在数据存储和检索过程中的作用。簇集索引通过物理排序实现了高效的数据访问，而非簇集索引则提供了更灵活的逻辑排序。理解这两种索引类型对于优化数据库性能至关重要。

最大区别在于clustered是物理上实现数据排序，并且同一个表里只能有一个clustered索引，而nonclustered是逻辑上的排序。
There are clustered and nonclustered indexes. 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. 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.

When a file is organized so that the ordering of data record is the same as or close to the ordering of data entries in some index , we say that the index is clustered , otherwise not clustered