View and update statistics recommendations with Visual Explain

To view and update statistics recommendations using detailed SQL performance monitor data:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Database.
  3. Click SQL Performance Monitors.
  4. Right-click the detailed SQL performance monitor you want to use and select List Explainable Statements.
  5. In the SQL statements monitored list, click on the SQL statement you want to visually explain.
  6. Click Visual Explain and the SQL statement is displayed, as a graph, in the Visual Explain window.
  7. From the Actions menu, select Advisor.
  8. Click the Statistics Advisor tab.
  9. You can choose to collect statistics on all the columns listed, or select specific columns for which you want to collect statistics. Then, you can choose whether to collect the statistics immediately or to process the statisitcs in the background.