Run Visual Explain while running the query
For long running queries, you can choose to launch Visual Explain while the query is running. By refreshing the Visual Explain
diagram, you can view the progress of the query.
- In the System i Navigator window, expand the system you want to use.
- Expand Databases.
- Right-click the database that you want to work with and select Run SQL Scripts.
- If you have an existing SQL statement that you want to use, copy that statement
and paste it into the Run SQL Scripts window.
- If you do not have an existing SQL statement, type a statement in the Run
SQL Scripts window.
- Highlight the text of your statement and select Explain While Running from the
Visual Explain menu.
- In the Visual Explain window, select Refresh from the Action menu or
click the Refresh button to update the environment information.