Use this section to run advisors and analysis tools on
an SQL statement.
You can carry out these
tasks:
- Set options
for the advisors, if you do not want to accept the
default options
- Run advisors, format and annotate an SQL
statement, and generate
an access plan graph
- Generate a report that summarizes the
analyses of the SQL statement
- For DB2® for z/OS® only: generate
a report that shows
statistics and other information for the tables, indexes, and predicates
that contribute to the access path for an SQL statement
- For DB2 for z/OS only: Test indexes virtually before
deciding whether to create them
- For DB2 for z/OS only: Create
a plan hint
For
help with these
tasks, see these topics: