就像你看到的,执行计划已经变为聚集索引扫描了。
相反,离线重新生成索引将会强制扫描聚集索引(或堆),因此会删除不一致。
Rebuilding the index offline, by contrast, will force a scan of the clustered index (or heap) and so remove the inconsistency.
扫描聚集索引,可以扫描全部内容,也可以只扫描一个范围。
Number of unrestricted full scans. These can either be base table or full index scans.
应用推荐