Use this section to review the results of running advisors,
tools, and reports for an SQL statement.
You can carry out these
tasks:
- View recommendations
of the advisors for the current SQL statement
- View an SQL
statement formatted for readability and annotated
with statistics and with other information
- View an access
plan graph for an SQL statement
- View a report that contains
the recommendations of the advisors
and other information in a single page
- For DB2® for z/OS® only: view
a report about the tables,
indexes, and predicates that are used in the access path for an SQL
statement
- Gather information about the environment in which
an SQL statement
is run and send that information to IBM® support
- For DB2 for z/OS only: view the results of testing indexes
virtually to see whether the indexes would improve the performance
of an SQL statement
- For DB2 for z/OS only: Create a plan hint
For help with these
tasks, see these topics: