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 Show Statements page for this workload by selecting Show Statements in the More actions field.
  3. Click the Refine button.
  4. Complete the steps in the Set Criteria for Capturing SQL Statements from the Current Query Workload wizard.
  5. Click Finish. The capture process starts, and a new workload is generated.

What to do next

You can tune the query workload as you would any other query workload.

Feedback