Run Visual Explain reactively (from detailed SQL performance monitor)
You can run Visual Explain using detailed SQL
performance monitor data. The data about the statement is collected by the
performance monitor and then can be explained later using
Visual Explain. To run Visual Explain using detailed SQL performance monitor
data:
- 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 Performance Monitors.
- Right-click the detailed SQL performance monitor 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.
You can also access the last four detailed SQL performance monitors through Run SQL Scripts.
- In the System i Navigator window, expand the system you want to use.
- Right-click Database and select Run SQL Scripts.