Indexing can improve database performance and facilitate reporting. Create a Declare Index rule to define criteria under which the Pega Platform automatically maintains index instances for faster access. An index can improve search and reporting access for properties that cannot be exposed as database columns because they are embedded within an aggregate property.
As an alternative to completing the rule form, you can use the Property optimization tool to create the rule, properties, and other required instances.
Index instances are sometimes called alternate keys or secondary keys. The system saves indexes as instances of concrete classes derived from the Index- base class.
Use the Records Explorer to list all declare index rules available to you.
Declare Index rules are instances of the Rule-Declare-Index class. They are part of the SysAdmin category.
Open topic with navigation