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.
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. |