After you have completed the prerequisites, you can choose from two options to implement table partitioning: create new partitioned tables or partition existing tables.

While identifying tables to partition, you might discover that for business or technical reasons you need to create new partitioned tables from scratch or that you need to partition existing non-partitioned tables in your database.

OpenEdge provides a few ways that you can use to create new partitioned tables or partition existing tables, depending on your preferences:

  • Using the Data Dictionary tool and the Database Administration Console
  • Using the Data Dictionary tool and the ABL API for Multi-tenant and Table Partition Management
  • Command line PROUTIL