You can
consolidate EXPLAIN information for a query workload
to reduce the amount of storage that information requires.
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.
To
consolidate EXPLAIN information about the SQL statements
that are in a query workload: