Stop Rebuilding Global Indexes! Oracle 12c Global Index Maintenance
Stop Rebuilding Global Indexes!
Stop rebuilding Global Indexes! Stop worrying about invalidating Global Indexes! Oracle 11g gave us “UPDATE GLOBAL INDEXES”. 12c provides a huge improvement: orphaned_entries! In this tutorial, Oracle Certified Master John Watson demonstrates how 11g and 12c handle Global Index maintenance with orphaned entries and overnight maintenance job PMO_DEFERRED_GIDX_MAINT_JOB.
Date: Jan 5, 2016
NOTE: Some corporate firewalls will not allow videos hosted by YouTube.