View and update index recommendations with Visual Explain
To view and update index recommendations:
- In the System i Navigator window, expand the system you want to use.
- Expand Database.
- Click SQL Performance Monitors.
- Right-click the detailed SQL performance monitor you want to use and select
List Explainable Statements.
- In the SQL statements monitored list, click on the SQL statement you want to visually explain.
- Click Visual Explain and the SQL statement is displayed, as a graph,
in the Visual Explain window.
- From the Actions menu, select Advisor.
- Click the Index Advisor tab.
- You can choose to create the recommended indexes by selecting the item in the Create column, then clicking
Create.