Run a Visual Explain with detailed performance monitor data
To run a Visual Explain of detailed performance monitor data:
- Open Run SQL Scripts.
- In the Run SQL Scripts window, select Recent SQL Performance Monitors from the
Visual Explain menu.
- On the Explainable Statements dialog, select a detailed performance monitor from the
Recent performance monitors list.
- From the statements in the SQL statements monitored list, click on the statement that you want to run a
visual explain for. The selected statement appears in the SQL statements selected box.
- Click Run Visual Explain.
Note:
- If you choose Explain from the Visual Explain menu, the system
only displays your query. If you choose Run and Explain from the
Visual Explain menu, your query is run by the system before it is displayed. Therefore,
running and displaying your query could take a significant amount of time.