Use this section to run advisors and analysis
tools on
an SQL statement or on a query workload.
Tuning single SQL statements
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
- Run a single SQL
statement in the Query
Text field directly. This is especially useful when you
need to run advisors and analysis tools on a statement that accesses
global temporary tables. You must run the statement that defines the
global temporary table in the workflow assistant before you run advisors
and analysis tools on the statement that you need to tune in the same
workflow assistant.
- 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:
Tuning
query workloads
You can carry out these
tasks:
- Set options for the advisors, if you do not want to accept the
default options
- Run workload advisors
- Generate a
report of information and statistics for the tables
that are referenced by statements in a query workload
For
help with these
tasks, see these topics: