Viewing 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 pureQuery, use the SQL Outline view to examine the data. With this view, you can also open tools that can help you to tune underperforming statements.

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 pureQuery > Show SQL Outline.
  2. In the toolbar for the SQL Outline view, 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.

Results

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

Note: 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