Consolidating EXPLAIN information

You can consolidate EXPLAIN information for a query workload to reduce the amount of storage that information requires.

Before you begin

About this task

You can schedule this task periodically to reduce the volume of information about the query workload that is maintained in EXPLAIN tables. Information about SQL statements might be recorded in the EXPLAIN tables several times, each time generating new records with new timestamps. By consolidating the records, you can reclaim a significant amount of disk space and improve the performance of the tools and advisors that analyze the SQL statements.

Procedure

To consolidate EXPLAIN information about the SQL statements that are in a query workload:

  1. On the Manage and Tune Workloads page, select the workload.
  2. In the More actions field, select Show Workload Tasks.
  3. On the Show Workload Tasks page, in the In the More actions field, select Schedule Statement Consolidation.
  4. Set options for the consolidation and schedule it to run as a task.

Feedback