Partitioned Tuning   «Prev 

Oracle Global Index

Creating a Range-Partitioned Global Index:

Example:The following statement creates a global prefixed index cost_ix on the sample table sh.sales with three partitions that divide the range of costs into three groups:

CREATE INDEX cost_ix ON sales (amount_sold)
GLOBAL PARTITION BY RANGE (amount_sold)
(PARTITION p1 VALUES LESS THAN (1000),
PARTITION p2 VALUES LESS THAN (2500),
PARTITION p3 VALUES LESS THAN (MAXVALUE));

Global index

A single global index for all table partitions

At the table level, the partitions are separate entities