Salesforce

Does the OpenEdge database have a table partitioning feature?

« Go Back

Information

 
TitleDoes the OpenEdge database have a table partitioning feature?
URL Name000031215
Article Number000172328
EnvironmentProduct: OpenEdge
Version: 11.4x and above
OS: All supported platforms
Other: Table Partitioning
Question/Problem Description
Does the OpenEdge Database have a Table Partitioning feature ?
Can the OpenEdge Database segment tables and indexes based on the data ? 
Are there any improvements in OpenEdge 11 to Data Storage design?
When migrating to OpenEdge 11 are there any physical database layout improvements to be taken advantage of?
Steps to Reproduce
Clarifying Information
Horizontal Table Partitioning
Error Message
Defect Number
Enhancement Number
Cause
Resolution
Horizontal Table Partitioning, where Partitioning refers to structuring data storage depending on the contents of the data, was introduced in OpenEdge 11.4, released in August 2014.

In OpenEdge Release 11.4, the OpenEdge RDBMS is enhanced with Horizontal Table Partitioning. Horizontal Table Partitioning allows Database Administrators to design a physical database layout that aligns Storage with specific data values or ranges. The physical separation of data into partitions can improve performance, maintenance, and data availability.  Later releases continue to build on the Table Partitioning support for OpenEdge Databases.

For a detailed overview of Table Partitioning, including basic concepts and planning considerations, see the OpenEdge Documentation References below.
 
Workaround
Notes
References to Other Documentation: 

Starting with the OpenEdge 11.4 Documentation Set:

OpenEdge Getting Started: New and Revised Features, Table Partitioning
OpenEdge Getting Started: Table Partitioning
OpenEdge Data Management: Database Administration, Maintaining and Monitoring Your Database, Table-partitioned database.
OpenEdge Management and OpenEdge Explorer: Managing Table Partitioning in Databases
OpenEdge Data Management: SQL Reference, Migrating data from existing unpartitioned tables to partitioned tables
OpenEdge Development: Programming Interfaces, ABL API for Multi-tenant and Table Partition Management

Progress Article: 
Which OpenEdge licenses allow to use the feature horizontal table partitioning?   
Keyword Phrase
Last Modified Date11/20/2020 7:30 AM

Powered by