You can use OEM or the OE SQL Editor to define partition policies on a partitioned table (that
is originally created using the Add Table wizard without any
partition policies defined on it). These partitioned tables are displayed along with the
other OpenEdge tables in the DB Structure view.
You can use the Add index wizard to create local and global indexes for a
partitioned table that has partition policy details defined on it. The index for a
partitioned table can be global or local. However, the default index created for a
partitioned table is a local index unless the explicitly marked as global.
By default, all the partitioned fields that are part of the partition policy details are
selected for a local index. If the Global
option is selected for
a partitioned table, only type II areas are displayed in the Area
field of the Add Index
wizard. The scope of the index
) is only applicable
to partitioned tables. For tables that are not partitioned, the default index created is
global. Local indexes are created only for partitioned tables and are partition-aligned
Note: A partition-aligned index is the index that has a partition key column
as the leading prefix of its constraint columns.