Run Visual Explain from SQL plan cache snapshot information
You can run Visual Explain using the information captured in a SQl plan cache snapshot.
- In the System i Navigator window, expand the system you want to use.
- Expand Databases and the database that you want to work with.
- Click SQL Plan Cache Snapshots.
- Right-click the snapshot that you want to use and select
Show Statements.
- Apply filtering information (if any) and click Refresh.
- Select 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.