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.
Procedure
To create a query workload from an XML file that defines
a query workload in the Optim Query
Workload Tuner schema:
- Select Exported Workload on the
left side of the Capture section to open the Capture
SQL from Exported Workload page.
- Browse to the XML file that represents the query workload.
- Click Capture.
- Click
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.