Try OpenEdge Now
skip to main content
Table Partitioning
Introducing Table Partitioning : Defining partitions : Defining a partition policy
 

Defining a partition policy

Defining a partition policy record requires you to define the table being partitioned and the attributes of the partition listed in the following table:
Table 1. Partition policy record
Property
Description
Policy name
A unique name for the partition policy. Do not use spaces or special characters such as the asterisk (*), the ampersand (&), and the period ( . ).You can use the underscore (_) character in addition to alphanumeric.
Description
A description of the partition policy.
Database connection
The database connection name of a table-partitioning-enabled database.
Table
The name of the table.
Default data area
The default storage area for the table’s data.
Default index area
The default storage area for the table’s indexes.
Default LOB area
he default storage area for the table’s LOBs.
Allocation
Object allocation rule
*None — Set new partitions not to allocate space (default). Use this option if you want to allocate space individually to new partitions when you create them later by adding partition policy details to the policy.
*Immediate — Set new partitions to allocate space. Use this option if you want to allocate space globally to new partitions when you create them later by adding partition policy details to the policy.
Has range
The table partition type
*No (unchecked in the OpenEdge Management wizard) — Indicates that the partition is a list partition or all list sub-partitions.
*Yes (checked in the OpenEdge Management wizard) — Indicates that the partition or your last sub-partition is a range.
Partition fields
Identifies the partition fields. You can easily select the fields with the Use Add field from table or Add fields from index to add partition fields. If a local index uses the selected field, the index appears in the Partition aligned indexes area.
Partition aligned indexes
Identifies partition-aligned indexes to use in the partitioning.