Creating a Globally Partitioned Index

Globally partitioned indexes essentially mean that the index has a different partitioning scheme and is partitioned based on a different column or set of columns than the data. This is primarily done to increase the performance of queries against the data in the database. Based on user queries against a given table, it may lend itself to having a globally partitioned index on a given queried column in order to improve query performance. See Figure 6-2 for an example of how a globally partition is constructed based on the data in a given table.

images

Figure 6-2. Globally partitioned index architecture

You can ...

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.