Summary
As a guideline, partitioned indexes should be used on partitioned tables. More specifically, locally partitioned indexes should be used whenever possible. Index maintenance on partitioned tables is far easier when using locally partitioned indexes, as noted in Table 6-1. There are, of course, exceptions based on application requirements. For instance, application requirements may dictate that the partitioning column(s) can't be part of a unique index that becomes the primary key. In cases such as these, you may simply have to implement a non-partitioned index. Alternatively, query performance using a globally partitioned index may be beneficial to warrant their use in certain circumstances.
As with many aspects of software development, ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
