...是复合索引,即包含几个列的索引;二是唯一性索引,即任意两行中的索引列不能有相同的取值;三是簇类索引 (Clustered indexes)和非簇类索引(Non
基于16个网页-相关网页
Non-Unique Clustered Indexes 支持非唯一聚集索引
For clustered indexes: if you are moving a clustered index you can use online processing.
对于聚集索引:如果要移动聚集索引,则可以使用在线处理。
UPDATE and DELETE operations are often accelerated by clustered indexes because these operations require large amounts of data to be read.
聚集索引通常可加快UPDATE和DELETE操作的速度,因为这些操作需要读取大量的数据。
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.
另外的解决方案,取决于具体的错误,可能是手工重建非聚簇索引,如果数据是静态的手工扔掉和重新载入表,诸如此类。
应用推荐