Comparing access plans by using snapshots of EXPLAIN information
Comparing access plans by using snapshots of EXPLAIN information after running the RUNSTATS utility
You can run the
RUNSTATS
utility to collect current statistics on tables and indexes. Running this utility provides the optimizer with the most accurate information with which to generate the best access plan.
Comparing access plans by using snapshots of EXPLAIN information after generating index recommendations
You can find out whether the access plans for a query workload would be improved by recommendations from the Workload Index Advisor.
Comparing access plans by using snapshots of EXPLAIN information after testing candidate indexes
You can find out whether access plans for a query workload would be improved by a set of indexes that you tested virtually.
Comparing access plans by using snapshots of EXPLAIN information after twice testing candidate indexes virtually
You can compare the differences in the access plans that are produced by two separate virtual tests of candidate indexes.
Related reference
:
Prerequisites for using EXPLAIN snapshots in comparisons
Prerequisites for using packages in comparisons
Finding and fixing changes to access plans
Feedback