[Oacle][Partition]Partition操作与 Index, Global Index 的关系

[Oacle][Partition]Partition操作与 Index, Global Index 的关系：

■ Regarding the local index and the global index,

In the case of "alter table add partition"

Even without using "update indexes" and "update global indexes"

Local index and global index are not unusable (remain VALID).

In the case of "alter table drop partition"

When "update indexes" and "update global indexes" are not used,

The status of the local index is not affected, the global index becomes unusable.

Using "update indexes"

The global index is not unusable (it remains VALID).

In case

Using "update global indexes"

■ Similar results were obtained in cases where nonpartitioned / local partition indexes were mixed:

Local indexes, global indexes, non-partitioned inexclusions are not unusable (remain VALID).

The status of the local index is not affected, the global index and the non-partitioned inex are unusable.

Global indexes and non-partitioned inexclusions do not become unusable (remain VALID).

本文转自健哥的数据花园博客园博客，原文链接：http://www.cnblogs.com/gaojian/p/3_15303168691.html，如需转载请自行联系原作者