Modifying global preferences

You can modify the values for a number of options that apply for every SQL statement and query workload that you tune.

About this task

Modifying these global options requires that you close all open instances of the workflow assistant for the changed values to take effect. Therefore, you should consider whether you want to modify them before you start capturing and tuning SQL statements and query workloads. You can, however, modify any of these values for individual SQL statements and query workloads before running advisors and tools by clicking Set advisor options on the left side of the Invoke section of the Query Tuner workflow assistant.

Options exist for all of the advisors. You can also set options for how to gather EXPLAIN information for SQL statements, options for tracing, and more. You can modify global options even if you are not currently connected to a database.

Procedure

To modify values for global options:

  1. In the main menu, select Window > Preferences.
  2. In the Preferences window, expand Data Management > Query Tuner.
  3. Select the Query Tuner page or any of its subpages to see the options that you can modify. If you are tuning without a license for InfoSphere® Optim™ Query Workload Tuner, you can modify any of the options that are on the Query Tuner, Access Plan Report, EXPLAIN Options, and Statistics Advisor pages. Only these pages apply to the no-charge query-tuning features.
  4. If you change values on a page, click Apply before moving to another page.
  5. After you are finished, click OK.

What to do next

If any instances of the workflow assistant are open, close them. You can save your work when you close them, and then reopen your work from the Project Explorer.


Feedback