Database indexes
When initially installed, the Pega Platform contains indexes that provide fast alternate access to rule information through the use of alternate (secondary) keys. These indexes have low or zero turnover (additions and deletions) in a production system. Other indexes support system operations such as locking and usage tracking, and can have high turnover.
For example, the database index
flow_pyClassName
associates flow names to
Work-
classes, and changes only when flows are added or deleted.
Index- objects, created by Declare Index rules ( Rule-Declare-Index rule type), support application-specific access.
Previous topic Adding and deleting database indexes Next topic Optimizing a schema