Comparing access plans for EXPLAIN snapshots of a workload

Use this comparison to validate that the SQL statements in a tuned workload have been optimized.

Before you begin

Procedure

To compare access plans in different EXPLAIN snapshots of a workload:

  1. Select the query workload to analyze.
    1. In the Data Source Explorer, connect to the subsystem with the packages for comparison.
    2. Expand the connection and open the workflow assistant by clicking Analyze and Tune > Start Tuning.
    3. 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.
  2. 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.

Feedback