You can improve the performance of a Java application by tuning the SQL statements
that are in the application.
When you enable a Java project
with Data Access Development support you can run, test, and tune the
SQL statements that are in your application. For some features, you
must also enable the Java project
with pureQuery support.
Adding support for developing and testing SQL statements in Java projects
If your Java application
runs SQL statements, you can simplify the development and testing
of SQL statements by adding data access development support to your Java project. With data access development
support, you can test SQL statements by running them from the Java editor and perform other tasks
when you develop Java applications
that run SQL statements.
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.
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.