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.

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.


Feedback