The workload advisors require current
EXPLAIN information
about the SQL statements in query workloads that they analyze. Run
an EXPLAIN task to gather this information.
About this task
You can schedule an EXPLAIN task to run immediately or at
some point in the future.
Procedure
To collect
EXPLAIN information about the SQL statements
that are in a query workload:
- On the Manage
and Tune Workloads page,
select the workload.
- Click the
button above the list
of workloads to open the Schedule page for the workload.
- Click the
button to open the Schedule
Collection of EXPLAIN Information window.
- Schedule
an EXPLAIN task. You can specify for
the workflow assistant to notify you when the EXPLAIN task is complete.
Results
The EXPLAIN task runs in the background, so
you can carry
out other tasks while it is running. To check the status of the task,
select the workload on the
Schedule page and
click the

button.
In some cases, the workflow assistant is not able
to collect EXPLAIN data for all SQL statements in a query workload.
However, you can continue to tune the query workload anyway.