[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"
The global index is not unusable (it remains VALID).

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

In the case of "alter table add partition"

Even without using "update indexes" and "update global indexes"
Local indexes, global indexes, non-partitioned inexclusions 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 and the non-partitioned inex are unusable.

Using "update indexes"
Global indexes and non-partitioned inexclusions do not become unusable (remain VALID).
In case
Using "update global indexes"
Global indexes and non-partitioned inexclusions do not become unusable (remain VALID).

转载于:https://www.cnblogs.com/gaojian/p/3_15303168691.html