IBM FileNet P8, Version 5.2.1            

Necessary indexes

For some simple queries, the necessary indexes can be easily identified and readily created with the administration console.

For example, without an index on Property1, the following query can be slow if the underlying table contains many rows:
SELECT Id 
FROM Document 
WHERE Property1 = 'value' 
To improve search performance, Property1 must be indexed if the following circumstances apply:
Table 1. Circumstances necessary for indexing
Circumstance Comment
Frequent searches The search is issued frequently, or a quickly returning search is important.
Relative small number of applicable rows The number of rows that satisfy the search is small relative to the total number of rows in the table.


Last updated: March 2016
p8ppt316.htm

© Copyright IBM Corporation 2016.