12c Asynchronous Global Index Maintenance Part II (The Space Between)

(Richard Foote) In Part I, I discussed how global indexes can now be asynchronously maintained in Oracle 12c when a table partition is dropped or truncated. Basically, when a table partition is dropped/truncated with the UPDATE GLOBAL INDEXES clause, Oracle simply keeps track of the object numbers o

Read More - Register for Free Membership