Creating a workload

Use the Create Workload window to create a new workload that will be used by the Index SmartGuide.

Note:

The workloads are stored in the ADVISE_WORKLOAD table. You can use the normal table functions, such as import or load, to move a large number of SQL statements into this table or use the export function to move a large number of SQL statements out of this table.

Fields and controls

Authorities and privileges

To create a workload:

1. Open the Create Workload window.

2. Enter a unique workload name in the Workload name field.

3. Do one or more of the following steps:

   • To import other SQL statements, click the Import push button. The Import SQL Statements window opens. Press F1 or click the Help push button for instructions on how to use this window.

   • To add other SQL statements, click the Add push button. The Add SQL Statement window opens. Press F1 or click the Help push button for instructions on how to use this window.

   • To change a SQL statement in the workload, select the SQL statement and click the Change push button. The Change SQL Statement window opens. Press F1 or click the Help push button for instructions on how to use this window.

   • To remove a SQL statement in the workload, select the SQL statement and click the Remove push button. The SQL statement is removed from the workload.

4. Click OK to create the workload.

Related information

• Index SmartGuide -- Overview
• Editing a workload
• Importing SQL statements
• Adding a SQL statement to a workload
• Changing a SQL statement in a workload