About the Property Optimization tool |
Use the Property Optimization tool in a development system to expose a top-level Single Value
property as a database column, and to populate the new column by extracting values from the Storage Stream (BLOB or pzPVStream) column.
The Property Optimization tool also can "expose" values of an embedded property by automatically creating an appropriate Index- class and Declare Index rule.
This capability is available if your development environment meets these prerequisite conditions:
From the Application Explorer, expand an application's "Data Model" node and right-click a property name. Select and select Optimize for reporting from the context menu to start a three- step screen flow.
Single Value
property, no additional inputs are needed. The tool creates a new database column and starts a background process to populate values for the new column (for existing instances of this class only) from BLOB values. Background processing may take minutes or longer, depending on volume, and computations in your applications involving the property value may fail or produce incorrect results until all background processing is complete.Select Designer Studio> System > Database > Column Population Jobs to see the status of jobs that are queued for background processing by the Pega-RulesEngine agent. If you use the Property Optimization wizard, ensure that this agent is enabled on at least one node of your system.
For details on understanding the display, see System — Database landing page.
Single Value
properties. For aggregate and embedded property values, this feature provides an alternative to the Declarative Index wizard .exposed column, production level, Storage Stream | |
About the Application Explorer
Working with the PegaRULES database — Table and column basics Understanding the Pega-RulesEngine agent |