Viewing workbench SQL performance data in the SQL Outline view

After you generate performance data for the SQL statements that are in a Java application that is enabled for Data Access development, use the SQL Outline view to examine the data. With this view, you can also open tools that can help you to tune statements that are not performing well.

Procedure

To view performance data in the SQL Outline view:

  1. If the SQL Outline view is not open, open it by right-clicking a project and selecting Data Access Development > Show SQL Outline.
  2. Click the arrow on the Show or Hide Columns button (Show or Hide Columns) and select Performance Columns. The information might take a few moments to appear in the view, depending on the size of your application and the amount of data that it gathers.
  3. In the SQL Outline view toolbar, select Workbench SQL performance from the Performance Data Type list.

Results

The SQL Outline view shows the following information for each SQL statement in the application that you generated performance data for:

Note for literal substitution: If your application is using pureQuery client optimization and you used the sqlLiteralSubstitution property when you captured SQL statements to a pureQueryXML file, SQL statements that contain literal values are nested under the versions of those statements that contain parameter markers.

For example, suppose that your application's pureQueryXML file contains this SQL statement:

SELECT * FROM GOSALES.INVENTORY WHERE PRODUCT_NUMBER = ?

When you run the application to generate performance data, the SQL statement runs with the literal value 115110. In the SQL Outline view, you must expand the statement that has the parameter marker to see the statement that has the literal value.

You can take any of the following actions while viewing performance data in the SQL Outline view:


Feedback