Try OpenEdge Now
skip to main content
Database Essentials
Administrative Planning : Database areas : Data area optimization

Data area optimization

Following a few simple rules can make your data areas easy to maintain and can provide optimal performance for users.
* Splitting off the schema
* Choosing an appropriate block size
* Keeping extents sized to eliminate I/O indirection
* Keeping areas small for offline utilities
* Always have an overflow extent for each area
* Enabling large files
* Partitioning data