Try OpenEdge Now
skip to main content
Online Help
Introducing Progress DB Navigator : Tasks : Working with OpenEdge databases : Viewing and maintaining OpenEdge database schema : Working with partitioned tables : Working with partitioned tables with partition policies
Working with partitioned tables with partition policies
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.