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)


Click here to go back to the Main OCM 11g Preparation page.

Have you enjoyed? Please leave a comment or give a 👍!

Leave a Reply

Your email address will not be published.