PEGA0034 alert: The number of declare indexes from a single interaction exceeds a threshold
The PEGA0034 alert is generated when an instance is saved and the number of indexes (instances of a concrete class derived from the Index- base class through Declare Index rules) created as a result of the save operation exceeds the specified threshold. This alert provides the number of index instances when the value is over the threshold.
Example message text
Number of indexes written for instance RULE-OBJ-MODEL DATA-ADMIN-OPERATOR-ID PYDEFAULT #20081215T181157.704 GMT exceeded threshold of 100: 141
Default prconfig.xml setting
<env name = “alerts/database/indexesperinstance" value="100" />
The threshold value is a positive integer that identifies the number of index instances. The default value is 100.
Reason for the alert
For reporting purposes, declarative indexes are useful for quickly finding work objects that have specific property values, especially embedded properties that cannot be exposed. While indexing these properties can speed query time (see PEGA0004 alert: Quantity of data received by database query exceeds limit), writing a large number of indexes is expensive and can impair performance. Review your application and determine whether all the index instances are necessary. As a best practice, do not create declarative indexes for top-level single value properties.