Creating query workloads from SQL statements that are in statement caches

You can create query workloads from SQL statements that are in a dynamic statement cache.

Before you begin

About this task

A dynamic statement cache captures all dynamic SQL and performance data when IFCID 0318 is enabled.

Procedure

To create a query workload from SQL statements in a dynamic statement cache:

What to do next

Collect EXPLAIN information about the SQL statements that are in the query workload.

Feedback