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.
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.
- Declare Index rules - Completing the New or Save As form
- Declare Index form - Completing the Indexes tab
Use this tab to convey how and when the system constructs an index in a database. The system forms an index instance from the Purpose key part of this rule and the handle of the base instance.
- Declare Index form - Completing the Pages & Indexes tab
Identify the name and class of clipboard pages that, at run time, contain properties referenced in the Indexes tab, on any page other than the page that contains the Source Class properties. See How to Complete a Pages & Classes tab for basic instructions.
- More about Declare Index rules