Creating query workloads from XML files that use the Optim Query Workload Tuner schema

You can define query workloads in XML files that are written according to the Optim™ Query Workload Tuner schema and then create query workloads from those files in the workflow assistant.

Before you begin

Procedure

To create a query workload from an XML file that defines a query workload in the Optim Query Workload Tuner schema:

  1. Select Exported Workload on the left side of the Capture section to open the Capture SQL from Exported Workload page.
  2. Browse to the XML file that represents the query workload.
  3. Click Capture.
  4. Click Save All Statements as a Workload in the toolbar above the list of captured SQL statements. The workflow assistant for query tuning opens the Manage and Tune Workloads page of the Manage section. The new workload is listed in the table on this page.

Feedback