Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Working Set
  • Character String
  • Problem Severity
  • Problem Type
  • A combination of the above four filter options
Profile CriteriaDescription
Working Set

The options located in the Scope area of the dialog enable you to filter problems based on defined Working Sets. A Working Set is a collection of user-defined Project files that you can organize, as needed, in

SQL Query Tuner

DB Optimizer. Select an option, and then click Select to define a Working Set to which the parameters apply. If no Working Sets exist, you need to define one or more via the New button on the Select Working Set dialog.

Select one or more Working Sets to which you want the criteria to apply. If no Working Sets exist, or none suitably match the current filter criteria, click New or Edit to define a new Working Set, or edit an exist Working Set, respectively.

Character String

Use the Description list to select contains or doesn't contain, as needed, and type the character string in the field below the list. The Problems view is filtered to only contain, or omit, problem descriptions that fully or partially match the string value.

Problem Severity

In the Where severity is area, choose Error, Warning, Info or some combination of the three check boxes. Only entries whose severity matches the check boxes you have selected remain visible in the Problems view.

Problem TypeThe options in the Types list on the right-hand side of the dialog enable you to filter problems by type. For example, deselect Problem to remove any system entries from the view, or deselect SQL Error Marker to remove any SQL code entries from the view.

Once you have defined and/or selected the appropriate filter profiles, the profiles will appear in the Show submenu in the Toolbar Menu of the Problems view. Select or deselect the profiles from the submenu, as needed. 


Scroll pdf ignore
Automate SQL tuning and profiling with DB Optimizer. Learn more > >