OCM 11g Preparation - Use partitioned indexes

I've already talked about this topic here and here. Basically we have 2 types of partitioned indexes: GLOBAL and LOCAL:

• Local Partitioned Indexes.
  • Local indexes can only be unique if the partitioning key is a part of the index key.
  • A bitmap index on a partitioned table must be a local index.
• Global Partitioned Indexes.
  • Note here that global indexes can only be partitioned, not subpartitioned.
  • Their partition type are only RANGE or HASH.

In this topic, I recommend you to create a partitioned table and practice creating 3 indexes on it:

1. Local prefixed
2. Local nonprefixed
3. Global prefixed

Path to Documentation:

VLDB and Partitioning Guide -> 3 Partitioning for Availability, Manageability, and Performance -> Index Partitioning

+1