About this task
In this procedure, before you run the RUNSTATS utility, you
create and explain a query workload that contains the SQL statements
that are in your application. Then, you run RUNSTATS. Finally, you
create and explain another query workload that contains the SQL statements
in your application, and compare the EXPLAIN snapshot for the first
query workload to the EXPLAIN snapshot for the second query workload.
Although
this procedure makes use of two separate query workloads, you can
create a single query workload, explain it, run RUNSTATS, and then
explain the query workload again. You can then compare the two EXPLAIN
snapshots.
To compare access plans by using snapshots of EXPLAIN
information after running the RUNSTATS utility: