Try OpenEdge Now
skip to main content
Table Partitioning
Introducing Table Partitioning : Indexes for table partitions
 

Indexes for table partitions

Two types of indexes support locating data within a partitioned table, as follows:
*Global
A Global index on a partitioned table spans all partitions. There is one index b-tree for all of the data, and provides uniqueness for non-partitioned columns.
*Partition-aligned local
A partition-aligned local index has one index b-tree for each partition.
Note: Word indexes can not be local indexes.