The Workload Statistics Advisor generates a number of RUNSTATS commands to collect necessary statistics for the tables that SQL statements in a query workload reference.
There are many situations where statistics are stale or conflict with each other. There are also situations where statistics might not have been collected. Collecting column-group statistics can be expensive. The Workload Statistics Advisor can decide which statistics are needed, so that you do not waste time and resources collecting statistics that you do not need to collect.
After the Workload Statistics Advisor generates RUNSTATS commands for collecting statistics, you can review the current state of the statistics and the problems that the advisor found in them. If you have the appropriate authorities on the database, you can run the RUNSTATS statements that you select.