Use this comparison to validate that the SQL statements
in a tuned workload have been optimized.
Procedure
To compare access plans in different EXPLAIN snapshots
of a workload:
- Select the query workload to analyze.
- In the Data Source Explorer, connect to the subsystem
with the packages for comparison.
- Expand the connection and open the workflow assistant
by clicking .
- Click the Manage tab to open
the Manage and Tune Workloads page. Select a query workload from the
table. The query workload must have at least two EXPLAIN
snapshots.
- To run the access plan comparison using the query workload
that you selected in step 1, click the Invoke Access
Plan Comparison icon.
What to do next
If the performance of the SQL statements meets your goals,
use the tuned workload.
If the performance of any SQL statements
regressed, you can take one of these actions.
- Create a query workload with the regressed statements. You can
then tune them collectively or individually. Then, rebind the packages.
- Create a plan hint and rebind the packages to apply the hint.