Skip to main content


Optimizing properties to speed up segment creation

Suggest edit Updated on September 21, 2021

To improve value retrieval performance when selecting segment criteria from a list, you can add and remove optimizations for properties which you plan to use to create segments. When you select criteria values from a list in a segment rule, you use the Select items dialog box to select one or more values for the criterion. If the property has many values, populating the Select items dialog box can result in poor performance. By optimizing the property, the number of values that are queried is reduced, resulting in improved retrieval performance.

  1. In the Application Explorer, in the search text field, enter Data-Admin-DistinctValueIndex and press Enter.
  2. Click Data-Admin-DistinctValueIndex to open the Data-Admin-DistinctValueIndex class.
  3. Click Create to create a distinct value index instance of the property that you want to optimize. You must define the property as a text, integer, or decimal type.
    1. In the Short description field, enter a brief description of the instance.
    2. In the Class name field, enter the name of the class that the property is associated with. The class cannot have security restrictions defined for it.
    3. In the Property name field, enter the name of the property whose values you want to retrieve.
    4. Click Save.Result: An agent calls the populateDistinctValues activity, which searches the specified class and caches the distinct values of the property in a table.
  4. Use the optimized property in a segment. For more information, see "Selecting Criteria Values from a List" in the Pega Customer Decision Hub User Guide on the Pega Customer Decision Hub product page.
    • Previous topic Extending and updating the MKTProfileHeaderSearchOverlay section
    Did you find this content helpful? YesNo

    Have a question? Get answers now.

    Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

    Ready to crush complexity?

    Experience the benefits of Pega Community when you log in.

    We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

    Close Deprecation Notice
    Contact us