...

• Global filters that affect all registered data sources in the SQL Query Tuner DB Optimizer development environment.
• Data Source specific filters affect only the specified data source for which they are defined.
•  On Sybase and SQL Server platforms, you can apply database filters, which enables you to set different filters on different databases within the same source.

...

• Define Data Source-Specific Object Filters
• Define Global Database Object Filters

Anchor
_DEFINE_DATA_SOURCE-SPECIFIC _DEFINE_DATA_SOURCE-SPECIFIC

Define Data Source-Specific Object Filters

Data source-specific object filters affect only the specified data source.

...

1. In Data Source Explorer, right-click the data source and select Properties.
   The Properties dialog appears. 
2. Select the SQL Filters node and select Enable data source-specific settings. The other controls on the dialog become enabled.
3. Click New. The Filter Template dialog appears.
4. Specify the parameters of the filter.
• In the Name field, enter the name of the filter as you want it to appear in the selection window on the SQL Filter node.
• The Database Type pane provides a list of data source objects. Deselect the data source objects that this template filters so that they do not appear in Database Explorer when displaying data source objects for the data source.
• Click New to add filter parameters for data source object properties. The New SQL Filter Predicate dialog appears. 
• Use the Property and Operator fields to supply the filter criteria. Property specifies whether the value is a Name or Schema, and Operator specifies the matching type of the filter syntax. (Equals, Not Equals, Like, Not Like, In, Not In)
• In the Value field, enter the full or partial syntax of the property or properties you want to filter in Data Source Explorer.
5. Click OK. The filter property specification is added to the Filter Template.
6. When you have finished defining the filter template, click OK. The template name is added to the Properties dialog. It can be enabled and disabled by selecting or deselecting the check box beside its name, respectively.

Anchor
_DEFINE_GLOBAL_DATABASE _DEFINE_GLOBAL_DATABASE

Define Global Database Object Filters

Global filters affect all registered data sources in the SQL Query Tuner DB Optimizer development environment. When you create and apply a global filter to a platform vendor in SQL Query TunerDB Optimizer, all databases associated with that vendor are affected by the filter, as defined.

...