You can collect EXPLAIN information for a query workload
without also running one or more workload advisors or generating a
report.
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.
- In the More actions field, select Explain
the Selected Workload. The Collect EXPLAIN
Information window opens.
Results
You can either run the EXPLAIN task immediately or schedule
it to take place later.
The EXPLAIN task runs in the background,
so you can accomplish other tasks while it is running. To check the
status of the task, select the query workload on the Show
Workload Tasks 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.