Skip to main content

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

Application performance

Updated on February 16, 2021

To ensure optimal performance under difficult conditions of load and volumes Pega Client Lifecycle Management for Financial Services comes with database indexes in relevant tables and columns.

Database indexes

There are certain database indexes that 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.



Associateinfo varchar_pattern_ops


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


pxinsname varchar_pattern_ops


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


pyid varchar_pattern_ops

Create index on this column and set the varchar_pattern_ops option.





Regenerate existing index in this column to use UPPER function.

Database column mappings

In the case of an upgrade, there are certain database column mappings that 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 are applicable to you and, for each of them, open the equivalent class at your implementation layer (using below UPlus as example) and, in the External Mapping tab, register them.

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. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us