Viewing the access plans for SQL statements
You can open Visual Explain to view the access plan for
an SQL statement as a graph. if you are using a DB2® or an Informix® Dynamic
Server data source.
Displaying SQL performance data in the SQL Outline view
The SQL performance data can be either captured from Java applications that you run on
the workbench or retrieved from an InfoSphere® Optim™ Performance Manager repository.
Finding underperforming SQL statements with EXPLAIN
In the SQL Outline view, you can view EXPLAIN data that
shows you statistics about the access plans for the SQL statements
in your Java application. You
can spot the underperforming statements that, when revised, can improve
the performance of the application.