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. Click the Schedule button above the list of workloads to open the Tasks page for the workload.
  3. Click the Consolidate button to open the Schedule Consolidation of EXPLAIN Information window.
  4. Set options for the consolidation and schedule it to run as a task.

Feedback