You can expose a top-level Single Value property as a database column, and populate the new column by extracting values from the storage stream (BLOB or pzPVStream) column using the Property Optimization tool in a development system. The tool creates a new database column and starts a background process that populates the values for the new column (for existing instances of this class only) from BLOB values. Background processing might take some time, depending on volume, and cause computations in your applications that involve the property value to fail or produce incorrect results until all background processing is complete.
You can also use this tool to "expose" values of an embedded property by automatically creating a concrete Index- class, properties for the new class, and a Declare Index rule that maintains the indexes. A background process creates the instances of the new Index-class.
You cannot optimize a transient property, because the column values would all be null. You cannot optimize properties in pega-based rulesets, abstract classes, or classes mapped to pr_other.
Your development environment must meet these prerequisites to use this tool: