Importing query workloads from .zip files that the Optim Query Tuner client exported or from XML files

You can create a query workload from a query workload that was exported from the client or from a query workload that is defined in an XML file that is written in the Optim™ Query Workload Tuner schema.

Before you begin

Procedure

To import a query workload:

  1. Click the Manage tab.
  2. In the Manage and Tune Workloads page of the Manage section, click the Import Workload. After you specify the workload to import, a new workload is listed in the table on the Manage and Tune Workloads page.

What to do next

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

Feedback