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
(
Global or
Local) 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
indexes.
Note: A partition-aligned index is the index that has a partition key column
as the leading prefix of its constraint columns.