IBM FileNet P8, Version 5.2.1            

Root class search and class-specific search

Using a class-specific search can improve performance of a sweep.

When running a sweep, you can a root class search or a class-specific search.

A root class search is a search for documents of all classes. When you run a root class search, the SQL that is generated does not specify the object_class_id in the WHERE clause. For example, the following SQL implements a root class search.
SELECT epoch_id, object_id, content_retention_date, create_date,
version_status, object_class_id, security_id, security_folder_id,
recovery_item_id, FROM DocVersion T0 WHERE (T0.home_id IS NULL AND
(object_id > {FE0A2438-EDD7-4825-A7DA-DEDBFA204440}))
ORDER BY object_id ASC FETCH FIRST 2000 ROWS ONLY OPTIMIZE FOR
2000 ROWS 
It is also possible to search over only a particular class. This kind of search is called a class-specific search. In a class-specific search, the WHERE clause is altered to include the object_class_id. The following search implements a class-specific search.
SELECT epoch_id, object_id, content_retention_date, create_date, 
version_status, object_class_id, security_id, security_folder_id,
recovery_item_id FROM DocVersion T0 
WHERE ((T0.object_class_id IN ({B4FDA997-1DFF-426e-AF31-616ED433F651})) and T0.home_id IS NULL 
AND (object_id > {FE0A2438-EDD7-4825-A7DA-DEDBFA204440}))
ORDER BY object_id ASC FETCH FIRST 2000 ROWS ONLY OPTIMIZE FOR 2000 ROWS

Using a class-specific search where possible improves the performance of the sweep, since fewer documents are examined.

To use a class-specific search, set the Sweep Target property to the specific class, and set the Include Subclasses to true if you want subclasses to be included in the sweep, and to false if subclasses should not be included. Setting the Sweep Target and Include Subclasses properties this way results in better performance than searching all classes and using a filter expression to choose the class.



Last updated: October 2015
p8ppt307.htm

© Copyright IBM Corporation 2015.