Try OpenEdge Now
skip to main content
Managing Table Partitioning in Databases
Managing Table Partitioning in a Database

Managing Table Partitioning in a Database

Table partitioning is a data organization scheme in which data is divided horizontally in a table by column value according to predefined data ranges or data values or a combination of both. Each data partition is stored separately in its database.
Table partitioning physically segregates data between partitions, improving performance, maintenance, and availability of the data by breaking up the partitioned table into smaller manageable segments. You can manage table partitioning and table-partitioning policies through the Database Administration Console.
You can perform table partitioning configuration from the Database Administration Console by:
*Establishing connections with table-partitioned databases — You can set up local and remote connections to managed databases with table partitioning. A list of these managed databases automatically appears in OpenEdge Management or OpenEdge Explorer.
You can also set up unmanaged local or remote database connections. Depending on the type of connection you set up, you can edit, copy, and delete it.
*Converting a database that is not enabled for partitioning into a database enabled for table partitioning — You can enable a database to support table partitioning.
*Creating a table partition policy — You can create and view a policy that includes details, such as default storage areas and an object-allocation rule, so that you can reuse the policy to create another.
* Enabling a database for table partitioning
* Creating a table partition
* Managing table partition policy details