Stop Rebuilding Global Indexes!
Duration: 50 hours
Free
Oracle 12c Global Index Maintenance
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.
-
Tutorial Lessons