Update statistics
Submitted by Vikram Khatri on Thu, 2007-02-01 16:37.
Did you know that you can run DB2 REORGCHK command to update the statistics on the tables? Normally, you would run RUNSTATS command against each table to update the statistics. Consider using REORGCHK as shown below:
- To update all the user and system tables use:
- To update all the tables of a particular schema use:
- To update all the tables of a particular table system use:
REORGCHK UPDATE STATISTICS ON TABLE ALL
REORGCHK UPDATE STATISTICS on SCHEMA schema_name
REORGCHK UPDATE STATISTICS on TABLE SYSTEM