| Tune SQL statements
that are captured from repositories in InfoSphere Optim Performance
Manager |
✓ |
✓ |
| Tune SQL statements
that are captured from text files |
✓ |
✓ |
| Generate recommendations
for creating 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
for creating or modifying statistical views |
✓ |
|
| Generate recommendations
for MQTs, multi-dimensional clustering, and redistributing data across
partitions |
✓ |
|
| 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 |
|
✓ |