Adding a SQL statement to a workload

Use the Add SQL Statement window to add one or more SQL statements to a workload that will be used by the Index SmartGuide.

Fields and controls

Authorities and privileges



To add a SQL statement to a workload:

  1. Open the Add SQL Statement window.

  2. In the SQL statement entry field, type or paste the SQL statement.

  3. In the Name field, enter the name of the SQL statement. This is the name that appears in the Name column of the Edit or Create Workload window.

  4. In the Frequency field, enter a frequency value. This is the value that appears in the Frequency column of the Edit or Create Workload window.

  5. Click OK or Apply to add the SQL statement to the workload.


Related information