全局索引又可分为 全局分区索引 ( global partitioned index )和全局非分区索引(global non-partitioned index),示例: 创建 全局分区索引 :
基于90个网页-相关网页
因为只在新附加分区上构建这一本地索引,并需要非常有限的日志,所以与全局索引相比,SET INTEGRITY甚至明显变快了。
Since this local index build happens only on the newly attached partition and requires very limited logging, SET INTEGRITY is still significantly faster compared to global indexes.
以下例子阐明了如何在不含全局索引的表上应用分区级别reorg ?
The following examples illustrate partition-level REORG on a table that has no global indexes.
A:索引查找利用全局索引扫描,来确定对分区的引用是否存在。
A: With global index scans, the index look-up determines whether a reference to a partition exists.
应用推荐