Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database

Choosing the Type of Index for Your Application

Using locally partitioned indexes is the most popular implementation of indexes on partitioned tables, especially in the data warehouse environment. One of the primary reasons is that locally partitioned indexes reduce the amount of index partition maintenance necessary overall when you perform table-level partition operations. Locally partitioned indexes are easy to create and much easier to maintain than their counterparts, the non-partitioned index and the globally partitioned index. While their use does reduce the amount of maintenance and time it takes to perform partition maintenance, using locally partitioned indexes doesn't eliminate maintenance entirely. That said, implementing locally ...