As the IBM® FileNet® P8 administrator or database administrator, you determine what constitutes the optimal set of database indexes for your system and needs. You do so by analyzing the queries that are typically run by your FileNet P8 applications.
Reason | Comment |
---|---|
Powerful query capability | Content Platform Engine supports customizable queries against classes and properties. These queries can be constructed with various operators and combinations of search conditions, joins, subqueries, and ordering. Also, queries can include the paging of results. |
Performance trade-offs | Some trade-offs are necessary to provide high performance overall in terms of both searching for and creating objects. Unnecessary indexes can degrade performance when objects are added or updated. |