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.