A partition is a division of a logical database into distinct independent parts. Database table partitioning allows you to make horizontal partitions of the table data based on a value or a range of one or more database table fields. This partitioning increases performance because the search involves limited views of data, while maintaining availability and security.
Note: A database must be enabled for table partitioning, by either using the PROUTIL command or from the OpenEdge Management console, to be able to partition the tables.
OpenEdge databases that are enabled for partitioning are categorized into two groups:
Partitioned tables with partition policies defined on them
Partitioned tables without any partition policies defined on them
You can use the DB Structure view to manage partitioned tables in the same way as the other OpenEdge database tables.
Partitioned tables with partition policies defined on them