Collecting EXPLAIN information about the statements in query workloads

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.

Before you begin

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:

  1. On the Manage and Tune Workloads page, select the workload.
  2. Click the Schedule button above the list of workloads to open the Schedule page for the workload.
  3. Click the EXPLAIN button to open the Schedule Collection of EXPLAIN Information window.
  4. 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 Refresh 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.


Feedback