Previous Topic: Add and Delete Keys FasterNext Topic: On-Demand Dynamic Extend


Multi-Dataset Index

The Multi-Dataset Index feature allows you to allocate unique index datasets for one or more key definitions (key IDs) in a given database. For applications with heavy index processing limited to a few key IDs, this allows you to optimize performance by using the Memory Resident Data Facility (MRDF) to selectively maintain the high-use key IDs in memory while allowing low-use key IDs to be serviced by the normal buffers and DASD. Also, if an index needs to be re-built, this system task can be focused on the affected index dataset which limits the downtime for production applications.

Note: For more information, see the Multi-Dataset Index chapter in the CA Datacom/DB Database and System Administration Guide.