Back Forward About the Property Optimization tool

Basics

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:

Starting the Property Optimization tool

From the Application Explorer, right-click a property name and select Optimize for Reporting from the context menu to start a three- step screen flow.

Status display

Select > 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.

Notes

Definitions exposed column, production level, Storage Stream
Related topics About the Application Explorer
Working with the PegaRULES database — Table and column basics
Understanding the Pega-RulesEngine agent

Related topics About the Application Explorer

Up Tools — System