Clustered tables are tables that have a clustered index 聚集表是有聚集索引的表。
For a clustered table , the row locator is the clustered index key 对于聚集表,行定位器是聚集索引键。
Indexed views have the same storage structure as clustered tables 索引视图与聚集表具有相同的存储结构。
Clustered tables , heaps , and indexes 聚集表、堆和索引
When a table has a clustered index , the table is called a clustered table 如果表具有聚集索引,则该表称为聚集表。
Not supported are range clustered tables , materialized query tables , and typed tables 不支持范围簇表( rct ) 、物化查询表( mqt )和有类型的表。
The structure of the row locator depends on whether the data pages are stored in a heap or a clustered table 行定位器的结构取决于数据页是存储在堆中还是聚集表中。
For example , if a clustered table has four partitions , there are four b - trees ; one in each partition 例如,如果一个聚集表有4个分区,那么将有4个b树,每个分区一个。
For every partition used by a table heap or clustered table , index , or indexed view , there is one row overflow data allocation unit 对于表(堆或聚集表) 、索引或索引视图使用的每个分区,都有一个row _ overflow _ data分配单元。
When a heap or a clustered table has multiple partitions , each partition has a heap or b - tree structure that contains the group of rows for that specific partition 当堆或聚集表具有多个分区时,每个分区都有一个堆或b树结构,其中包含该指定分区的行组。