Using the SQL Outline view to test the performance of the SQL statements in a Java application

When you use a pureQuery Run configuration to run a Java™ application, you can use the SQL Outline view to evaluate data about the speed at which the associated database ran the SQL statements that are in the application.

After you find out which SQL statements are underperforming, you can view their access plans in Visual Explain. You can also tune them with Optim™ Query Tuner or Optim Performance Manager.

You can also compare current data with past data to determine whether changes that you made to SQL statements improved their performance.


Feedback