Testing the performance of the SQL statements in a Java application with the SQL Outline view

When you use a Data Access Development 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 InfoSphere™ Optim™ Query Tuner.

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


Feedback