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, Version 3.1 or 3.1.1 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.
In most cases, to tune an SQL statement with the no-charge query-tuning features in the Query Tuner Workflow Assistant, you can follow these steps.