title: asynchronous global index maintenance for drop and truncate partition
body: <p>We have a very large partitioned table that needs to drop partition periodically. The business system needs 7*24 hours of operation.</p>
  <p>We use global index.</p>
  <p>From the following article, we know that Oracle supports asynchronous index update.</p>
  <p><a href="https://oracle-base.com/articles/12c/asynchronous-global-index-maintenance-for-drop-and-truncate-partition-12cr1" rel="nofollow noreferrer">https://oracle-base.com/articles/12c/asynchronous-global-index-maintenance-for-drop-and-truncate-partition-12cr1</a></p>
  <p>But : &quot;The actual index maintenance is performed at a later time&quot;\</p>
  <p>Does it affect the normal business when it is actually executed.( Query/Insert/Update/Delete )</p>