IBM FileNet P8, Version 5.2            

Creating database indexes for class properties

To optimize the performance of those queries that search a class property, create an index for the property in the object store database. The property cannot be a system property.

Important: The addition of each new database index increases the time that Content Platform Engine takes to add documents to an object store. A performance trade-off therefore exists between adding documents and running queries. For this reason, create a database index only for a property that you search frequently. For more information about the effect of indexes on query performance, see Tuning database queries.


Feedback

Last updated: June 2013
pr_create_db_column_indexes.htm

© Copyright IBM Corporation 2014.
This information center is powered by Eclipse technology. (http://www.eclipse.org)