Creating a query workload as a subset of SQL statements in an existing query workload

You can create a query workload from a query workload that is already listed in the Manage section.

Before you begin

Procedure

To create a workload from a workload that is listed on the Manage and Tune Workloads page of the Manage section:

  1. On the Manage and Tune Workloads page, select the workload that you want to create a new workload from.
  2. Open the Statements page for this workload by clicking the Show Statements button.
  3. Click the Refine button on the toolbar.
  4. Complete the steps in the Refine Workload wizard.
  5. Click Finish. The capture process starts, and a new workload is generated.

What to do next

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

Feedback