View and update index recommendations with Visual Explain

To view and update index recommendations:

  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 Index Advisor tab.
  9. You can choose to create the recommended indexes by selecting the item in the Create column, then clicking Create.