OCM 11g Preparation – Maintain indexes on a partitioned table

Now that you know how to manage the partitions, start working with their indexes:

• Rebuilding Global Index Partitions
  • Rebuild each partition by issuing the ALTER INDEX … REBUILD PARTITION statement (you can run the rebuilds concurrently).
  • Drop the entire global index and re-create it. This method is more efficient because the table is scanned only one time.
• Rebuilding Local Index Partitions
  • ALTER INDEX … REBUILD PARTITION/SUBPARTITION
  • ALTER TABLE … MODIFY PARTITION/SUBPARTITION … REBUILD UNUSABLE LOCAL INDEXES
• When managing the partitions, check if you might use UPDATE GLOBAL INDEXES

Path to Documentation:

Database SQL Language Reference -> ALTER INDEX
VLDB and Partitioning Guide -> 4 Partition Administration -> Maintaining Partitions (Rebuilding Index Partitions) – (Good for copy paste examples during the exam)

+1