Generating statistics recommendations

The statistics advisor recommends RUNSTATS commands that you can use to collect or repair statistics.

Procedure

To generate statistics recommendations:

  1. Create a tuning task on single query or workload, with Recommend RUNSTATS commands tuning option selected.
  2. When the tuning task is completed, go to Tuning > Tuning results page to view the result list.
  3. In the Tuning results page, select the tasks with the Result displaying as Success and click View result.
    The Advisor recommendations page displays.
  4. Click Statistics from the Advisors menu.
    The Runstats recommendations, generated by the Statistics Analyzer, are displayed in the table.

    The Runstats recommendations table lists all the tables that are accessed by the queries in the single-query or workload and provides recommendations for updating their associated catalog statistics.

  5. To apply the statistics recommendations, select the recommendations in the Runstats recommendations table and then click Apply runstats.