You can improve the performance of SQL statements in applications
that access DB2® for Linux, UNIX,
and Windows and DB2 for z/OS®.
About this task
Although there is no predetermined order in which to use
the advisors, analysis tools, and reports for tuning an SQL statement,
there is a general order on which you can base your own tuning scenarios.
In most cases, to tune an SQL statement, you can follow
these steps.