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 -
Does Pega OOTB defrag rebuilds or reorganizes the index or does both?
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***