Use the database catalog filter in the Administration
Explorer to limit the number of objects that are returned
from the database catalog.
For databases that contain a large number of objects, you might
get improved performance by specifying a database catalog filter.
Only the data objects that meet the conditions and match the dependent
object types that you specify in the filter are returned from the
database catalog. You can also use a view filter in combination with
the database catalog filter to further filter the data objects that
display in a view.
Specifying a filter
To specify a database
catalog filter, right-click an object type folder in the Administration
Explorer and select Database Catalog Filter.
You can specify a filter for each object type folder.
You must
specify conditions and the types of dependent objects to enable a
database catalog filter:
- Conditions
- Specify a predicate and value for each condition. You can include
or exclude data objects based on the characters in the name of the
object. The values that you specify are case-sensitive.
- Dependent objects
- Specify the types of dependent objects to return from the database
catalog. These objects are returned from the database catalog only
if they are dependent on an object that meets the conditions that
you specify in the filter.
Remember: To analyze impact
and dependency for data objects, you must either include all dependent
object types or disable the database catalog filter.
When a filter is set, the following labels and
icon appear in the
Administration Explorer:
- [FILTERED]
- Displays in front of the name of the database where you specified
the filter.
- [Filtered]
- Displays after of the filtered folder
where you specified the filter.
To disable a filter, you must delete all the
conditions in the database catalog filter.
Restriction: Specifying
the data object filter in the Data Source Explorer while
the database catalog filter is specified in the Administration
Explorer is not supported. Only one of these filters can
be enabled in the workbench because each filter overrides the other.
For example, if you specify the data object filter, the database catalog
filter is automatically disabled and all the conditions are deleted.
Setting a threshold limit for the Object List
To
improve performance, you can set a threshold for the number of objects
to show in the Object List.
You set that threshold in the Preferences dialog
box. If you try to open a list of objects from the Administration
Explorer and the number of objects to include in the list
exceeds the threshold that you set, the workbench will display a filter
dialog box before it populates the Object List. You can choose to
use the filter to limit the number of objects that are shown or to
view the full list of objects.
Depending on the performance
of your Object List, you can increase or decrease
the limit in the preference to specify when the filter dialog box
is automatically opened: .