IBM FileNet P8, Version 5.2.1            

Common query checks

Examine the user interface of FileNet P8 applications to see what kinds of queries can be executed. In some cases, when possible, a search interface has to be designed to prevent slow queries from being executed.

The following table shows some of the items to check.
Table 1. Query items to check
Item Comment
Selective search conditions If frequently executed queries contain search conditions with selective properties, index at least some of these properties. For more information, see Index tuning: Selective search conditions.
Case-insensitive searches Check whether your object store is configured for "Force Case-Insensitive Search". For more information, see Index tuning: Case-insensitive search.
Wildcards A query cannot use an index if a search value has a wildcard at the front of the value. For example, a database property "CONTAINS" search runs slow because a LIKE '%value'. Changing the default for the search to be "STARTS WITH" makes the entire system much faster by eliminating table scans. For more information, see SQL tuning: Wildcard usage.


Last updated: October 2015
p8ppt265.htm

© Copyright IBM Corporation 2015.