本文详细介绍了数据库中的两种索引类型：聚簇索引和非聚簇索引。聚簇索引改变了表中记录的实际存储顺序，并且每个表只能有一个聚簇索引；而非聚簇索引的逻辑顺序与磁盘上的行存储顺序不一致，其叶节点包含的是索引行而非数据页。
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.
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.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
