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.
The no-charge features are so-called because they do not
require an active license for IBM® InfoSphere® Optim™ Query Workload Tuner on the DB2 databases and subsystems that you tune SQL
statements for. These features are a subset of the features that are
available in InfoSphere Optim Query Workload Tuner. For
a comparison of the no-charge features and the features that are in
that product, see Features by product.