| Tune SQL statements
that are captured from repositories in InfoSphere Optim Performance
Manager |
✓ |
✓ |
| Tune SQL statements
that are captured from text files |
✓ |
✓ |
| Generate recommendations
and DDL for creating and modifying indexes |
✓ |
✓ |
| Generate RUNSTATS
commands for fixing problems with statistics |
✓ |
✓ |
| Tune SQL statements
that are captured from all supported sources in DB2 for Linux, UNIX, and Windows, including the package cache, packages,
and SQL stored procedures |
✓ |
|
| Generate recommendations
and DDL for creating or modifying statistical views |
✓ |
|
| Generate recommendations
and DDL for MQTs, multi-dimensional clustering, and redistributing
data across partitions |
✓ |
|
| Generate recommendations and scripts for migrating
row-organized tables to column-organized tables |
✓ |
|
| Tune SQL statements
that are captured from all supported sources in DB2 for z/OS,
including the dynamic statement cache, plans, packages, and SQL stored
procedures |
|
✓ |
| Compare, annotate,
and generate reports on the access plans and estimated cost changes
for SQL statements in different packages or workloads |
|
✓ |
| Create reports
on the catalog information for tables that SQL statements reference |
|
✓ |
| Generate recommendations
for improving access paths |
|
✓ |
| Generate recommendations
for rewriting SQL statements |
|
✓ |
| Capture the
environments of query workloads; send representations of the environments
to IBM Support or re-create
the environments on another subsystem |
|
✓ |