Tuning

You can use Db2 Data Management Console to tune both a single SQL statement and query workload to improve performance through reduced response times and increased throughput.

Creating a tuning task
You can create a tuning task for a single SQL statement or query workload.
Choosing EXPLAIN and tuning options
In the Select tuning activities to run window, you can configure the default set of EXPLAIN and tuning options.
Generating access plan graph
Access plan graph is a visual representation of an access plan. You can choose to generate an access plan graph for selected SQL statements that reside on a connected Db2 subsystem, by using appropriate tuning options.
Generating statistics recommendations
The statistics advisor recommends RUNSTATS commands that you can use to collect or repair statistics.
Generating index recommendations
This task is about generating and viewing the index recommendations.
Doing an index what-if analysis
You can do an index what-if analysis for a single query or a workload tuning task.
Changing table organization
You can analyze tables to change the organization to column-organized for improving performance.

Parent topic: Working with integrated databases using the Db2 Data Management Console