IBM FileNet P8, Version 5.2.1            

Improving Content Consistency Checker queries that return more than a million rows

Consider creating an index if the queries that are associated with Content Consistency Checker document re-indexing by document class return a million or more records.

Create the index by using the following SQL command:
create index I_STORAGE_OBJID on docversion (storage_area_id, object_id)

To improve the performance of document insertions and document updates, as well as reduce storage costs, you can remove this index after you have completed the associated tasks. However, if the operations are performed on a regular basis, you might want to keep the index to avoid having to create it more than once.



Last updated: March 2016
p8ppt155.htm

© Copyright IBM Corporation 2016.