Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Managing Performance : Alternate Buffer Pool : Designating objects to the Alternate Buffer Pool : Specifying objects for the Alternate Buffer Pool
 
Specifying objects for the Alternate Buffer Pool
You can identify objects for the Alternate Buffer Pool with Alternate Buffer Pool Maintenance in Data Administration. The objects must reside in a Type II area to be individually designated for the Alternate Buffer Pool. Object-level assignments can be made while the database is online or while the database is in single-user mode.
For ABL objects, use Data Administration, and choose Admin > Alternate Buffer Pool > Alternate Buffer Pool Maintenance. Follow the progression of dialog boxes to select and deselect objects and designate objects for the Alternate or primary buffer pools. For details, see the Data Administration online Help, or OpenEdge Development: Basic Database Tools.
For SQL objects, you can designate objects to the Alternate Buffer Pool with the CREATE/ALTER TABLE and CREATEALTER INDEX statements. For details on these statements, see OpenEdge Data Management: SQL Development.