Changing a SQL statement in a workload

Use the Change SQL Statement window to change a SQL statement in a workload that will be used by the Index wizard.

Fields and controls

Authorities and privileges



To change a SQL statement in a workload:

  1. Open the Change SQL Statement window.
  2. Optional. In the SQL statement entry field, edit the SQL statement.
  3. Optional. In the Name field, update the name of the SQL statement. This is the name that appears in the Name column of the Edit or Create Workload window.
  4. Optional. In the Frequency field, update the frequency value. This is the value that appears in the Frequency column of the Edit or Create Workload window.
  5. Click OK to update the statement in the workload and return to the Edit or Create Workload window.


Related information