"Update Global Indexes" Allows Automatic Global Index Maintenance During DDL
(Doc ID 139707.1)
Last updated on AUGUST 04, 2018
Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
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 (composite)
2. Which performance considerations would lead to choose REBUILD INDEX rather than using UPDATE GLOBAL INDEXES.
For all DBAs maintaining partitioned tables owning GLOBAL indexes.
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.