Ensuring that the local cache of the system catalog is current

When the workflow assistant collects EXPLAIN information for SQL statements, the workflow assistant collects that information from a local cache of the catalog for the connected database or subsystem. Therefore, when the catalog changes, the local cache of the catalog must be updated before the workflow assistant collects EXPLAIN information again for the same SQL statements.

Procedure

To ensure that the local cache of the system catalog is always updated after updates to the catalog occur, follow either of these steps:

What to do next

You can run the Statistics Advisor and tools on the current SQL statement after ensuring that the Re-explain the query option is selected on the Run Single-Query Advisors and Tools page of the Invoke section.

Feedback