IBM FileNet P8, Version 5.2.1            

Creating an index to improve sweep performance

You can increase the performance of policy-based and job sweeps by creating a covering index on the base table you are sweeping.

A covering index must contain all columns that are included in the select list of the database sweep query, and must define OBJECT_ID as a unique value. Including all columns in the covering index ensures that the sweep query traverses only the index, and does not access the underlying data pages.

To create a covering index, do one of the following steps:



Last updated: March 2016
p8ppt237.htm

© Copyright IBM Corporation 2016.