Question

30
Views
Close popover
Manisha Singh Tanwar (ManishaT1945)
Cognizant Technology Solutions

Cognizant Technology Solutions
IN
ManishaT1945 Member since 2017 1 post
Cognizant Technology Solutions
Posted: March 18, 2021
Last activity: March 18, 2021

Defragmentation strategy

We are planning to update the OOTB defragmentation strategy of pr_sys_locks table from DAILY to an interval of 6 hours. Also, in parallel we are planning to rebuild the index on the table from the DB side.

We are looking for some insights/inputs on the below -

  1. Does Pega OOTB defrag rebuilds or reorganizes the index or does both?
  2. Will there be any locking issues during this process?

Sorry, if we have missed any important links related to this topic. Any help would be highly appreciated.

***Edited by Moderator Marissa to update Support Case Details***
Pega Platform 7.4 System Administration System Architect Support Case Exists