System Modification After Optimization
Because optimizing a database adds column statistics and histogram information to the system catalogs, you should run the system modification operation on your database after optimizing it.
Running system modification modifies the system tables in the database to optimize catalog access. You should do this on a database periodically to maintain peak performance.
Run System Modification
To run system modification, use any of the following methods:
• At the command line, use the sysmod command.
• In Director, use the Modify System Tables dialog.
• In VDBA, use the System Modification dialog.
Examples:
Modify the system tables in the empdata database:
sysmod empdata
Modify only the system tables affected by optimizedb:
sysmod empdata iistatistics iihistogram
Last modified date: 01/30/2023