Indexes for table partitions
- Last Updated: October 26, 2026
- 1 minute read
- OpenEdge
- Version 13.1
- Documentation
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.
- PROUTIL IDXMOVE does not support moving an inactive local or global index of a partitioned table. For more information, see PROUTIL IDXMOVE.