聚簇索引 clustered index
非聚簇索引 nonclustered indexes ; Non- Clustered Index ; non-cluster index
哈希簇索引 hash cluster index
平衡树簇索引 B-tree cluster index
哈希聚簇索引 Hash cluster indexes
如何建立散列聚簇索引 clustered hash index
表上原来的聚簇索引 SalesOrderDetailID ; SALESORDERID
树聚簇索引 tree cluster index
簇索引访问 Clustered index access
另外的解决方案,取决于具体的错误,可能是手工重建非聚簇索引,如果数据是静态的手工扔掉和重新载入表,诸如此类。
Additional solutions, depending on the errors, may be to manually rebuild non-clustered indexes, manually drop and reload a table if the data is static, and so on.
如果一个数据块被分配给一个表或者簇表的数据段,或者被分配给一个索引的索引段,那么可用空间区还可能存储事务条目。
In data blocks allocated for the data segment of a table or cluster, or for the index segment of an index, free space can also hold transaction entries.
如果源表不包含主键或聚簇的索引,该工具可以自动添加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.
应用推荐