利用内部表的索引恰好是一个聚集索引。
The index exploited for the inner table happens to be a clustered index.
你的聚集索引顺序表中的数据存储，所以你每个表只能有一个聚集索引。
Your clustered index is the order the data is stored in the table, so you can only have one clustered index per table.
重新组织索引时，除了重新组织一个或多个索引外，默认情况下还将压缩聚集索引或基础表中包含的大型对象数据类型(lob)。
Besides reorganizing one or more indexes, large object data types (LOBs) that are contained in the clustered index or underlying table are compacted by default when an index is reorganized.
索引视图与聚集表具有相同的存储结构。
Indexed views have the same storage structure as clustered tables.
聚集索引确定的顺序记录物理存储(这就是为什么你每个表只能有一个)。
A clustered index determines the order in which records are physically stored (which is why you can only have one per table).
如果源表不包含主键或聚簇的索引，该工具可以自动添加rowid列和列上的聚集的索引设置转换过程中。
If the source table doesn't include a primary key or clustered index, the tool can automatically add a ROWID column and set the clustered index on the column during the conversion.
如果源表不包含主键或聚簇的索引，该工具可以自动添加rowid列和列上的聚集的索引设置转换过程中。
If the source table doesn't include a primary key or clustered index, the tool can automatically add a ROWID column and set the clustered index on the column during the conversion.
应用推荐