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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.