Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Application performance

Updated on January 13, 2022

To ensure optimal performance under difficult load and volume conditions, Pega Client Lifecycle Management and KYC comes with database indexes in relevant tables and columns.

Pega Client Lifecycle Management for Financial Services Implementation Guide

Database indexes

Certain database indexes cannot be automatically created in all the environments and database vendors. The table below contains some database indexes to address common performance related issues that, depending on your environment, load and use of the system, you might be experiencing.

DatabaseTable/ColumnsAction
PostgreSQL

pc_data_workattach

Associateinfo varchar_pattern_ops

pxobjclass

Regenerate existing index on these columns to add the varchar_pattern_ops option.
PostgreSQL

pc_data_workattach

pxinsname varchar_pattern_ops

pxobjclass

Regenerate existing index on these columns to add the varchar_pattern_ops option.
PostgreSQL

pc_work_masterprofile

pyid varchar_pattern_ops

Create index on this column and set the varchar_pattern_ops option.

Oracle

PostgreSQL

pc_work_masterprofile

UPPER(customertype)

Regenerate existing index in this column to use UPPER function.

Database column mappings

In the case of an upgrade, specific database column mappings need to be added manually to the classes of your implementation layer. These mappings ensure that the application works and performs as expected.

Determine the items from the list below that apply to you. For each of them, open the equivalent class at your implementation layer (for example, using below UPlus) and register them in the External Mapping tab.

Upgrade from 8.4 version or earlier

Functional areaClassColumn nameProperty name
Group ManagementUPlus-Work-CLMGroupID_2.GroupInfo.GroupID
Group ManagementUPlus-Work-CLMGroupName_1.GroupInfo.GroupName
Group ManagementUPlus-Work-CLM-GroupManagementGroupID_1.GroupEntity.GroupID
Group ManagementUPlus-Work-CLM-GroupManagementGroupID_2.GroupInfo.GroupID
Group ManagementUPlus-Work-CLM-GroupManagementGroupName_1.GroupInfo.GroupName

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us