For an overview of InfoSphere® Optim™ Query Workload Tuner, see Overview of IBM InfoSphere Optim Query Workload Tuner, Version 3.1.1.
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.