You can get recommendations for improving the performance
of groups of SQL statements that access the same DB2® for z/OS® subsystem.
About this task
Although there is no predetermined order in which to run
the advisors for tuning a query workload, 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.