16. Using the Query Optimizer : Database Statistics : System Modification After Optimization
 
Share this page                  
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.