You can tune SQL statements In the IBM® Data Studio client, Version 3.1.1 either
with the no-charge tuning features or with IBM InfoSphere® Optim™ Query Workload Tuner, Version
3.1.1.
Tuning single SQL statements with the no-charge query-tuning features in the workflow assistant
You can use the no-charge query-tuning features improve
the performance of SQL statements in applications that access DB2® for Linux, UNIX,
and Windows and DB2 for z/OS®.
You can format SQL statements so that they are easier to read, generate
visual representations of access plans, and get recommendations for
collecting statistics on the objects that a statement references.
You can also generate a report that summarizes information about the
access plan and includes the recommendations.
Tuning with InfoSphere Optim Query Workload Tuner, Version 3.1.1
IBM InfoSphere Optim Query
Workload Tuner helps database administrators and SQL developers optimize
the performance of SQL statements and query workloads in applications
that query DB2 for Linux, UNIX,
and Windows databases and DB2 for z/OS subsystems.
Managing Query Tuner projects and workspaces
When you are tuning SQL statements and query workloads,
you can save your work into Query Tuner projects, which you can export
and share with other people. You can also set preferences that apply
to all Query Tuner projects that are in a workspace. When you share
a project, you can also share these global preferences.