My Oracle Support Banner

"Update Global Indexes" Allows Automatic Global Index Maintenance During DDL (Doc ID 139707.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Purpose

 This bulletin explains:

1. The new clause "UPDATE GLOBAL INDEXES" and when it can be used in operations performing DDL on table partitions, depending on the type of partitioning and the type of DDL performed: 

* range
* hash
* range hash (composite)
* list

2. Which performance considerations would lead to choose REBUILD INDEX rather than using UPDATE GLOBAL INDEXES.

Scope

 For all DBAs maintaining partitioned tables owning GLOBAL indexes.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Prerequisites
 1. UPDATE GLOBAL INDEXES clause and ADD PARTITION clause
 2. UPDATE GLOBAL INDEXES clause and DROP PARTITION clause
 3. UPDATE GLOBAL INDEXES clause and SPLIT PARTITION clause
 4. UPDATE GLOBAL INDEXES clause and MERGE PARTITION clause
 5. UPDATE GLOBAL INDEXES clause and EXCHANGE PARTITION clause
 6. UPDATE GLOBAL INDEXES clause and MOVE PARTITION clause
 7. UPDATE GLOBAL INDEXES clause and TRUNCATE PARTITION clause
 8. UPDATE GLOBAL INDEXES clause and COALESCE PARTITION clause
 Which performance considerations would lead you to choose REBUILD INDEX rather than use UPDATE GLOBAL INDEXES :
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.