clustered和nonclustered索引的区别

最新推荐文章于 2024-12-06 23:59:48 发布

最新推荐文章于 2024-12-06 23:59:48 发布 · 179 阅读

本文详细解析了数据库中聚簇索引与非聚簇索引的区别：聚簇索引按索引顺序存储数据，每个表仅能拥有一个；而非聚簇索引则在逻辑上对数据进行排序，其叶子节点不包含实际的数据页。

最大区别在于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.