These conflicting operations include: compress, repack, shrink, alter, online indexbuild, truncate, and drop.
这些冲突操作包括:压缩、重新打包、收缩、更改、在线索引构建、截断、以及删除。
2
Since this local indexbuild happens only on the newly attached partition and requires very limited logging, SET INTEGRITY is still significantly faster compared to global indexes.
To help ensure that building the initial index has limited impact on users, the common practice is to schedule the first indexbuild process to occur during periods of low reporting usage.