OpenEdge Table Partitioning can greatly enhance the availability, manageability and performance of almost any enterprise database. By partitioning tables into smaller, more manageable units, database administrators use a "divide and conquer" approach to data management.
- More focused maintenance
- Considerable flexibility in partition management
- Greater query efficiency
- Transparency to the application, with minimal changes required
Because queries can be pruned to isolate index usage for a particular partition—and the index for that partition—they run more efficiently. Even better, spreading index contention across multiple indices removes the all-too-familiar single-index bottleneck.