Question
Cognizant
SE
Last activity: 9 Jul 2018 10:28 EDT
Long running query on pr_Index_PegaFS_Data_OrgChartW table
Hi All,
Finding below long running query do we really required data in this table or can we disable the declare index.
*com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl*|xx.xx.xx.xx*existing requestor retrieved*Rule-Obj-Activity:pzGetURLHashes*DATA-ADMIN-OPERATOR-ID UPDATEOPERATORID #20131010T173711.855 GMT Step: 1 Circum: 0*NA*****Database update took more than the threshold of 500 ms: 7,492 ms SQL: delete from XXXX.pr_Index_PegaFS_Data_OrgChartW where pxInsIndexedKey = ? and pxIndexPurpose = ?*
***Updated by moderator: Lochan to update platform capability***
Pegasystems Inc.
IN
Hi Deva,
Can you please check what is the name od Declare Index.
We would like to check why it has contributed to such huge data.
Any way we see that there is purge activity that intends to delete the rows and hence by the nature of deletes we can understand if the DC is actually required.
Regards,
Ujjwal
Cognizant
SE
Hi Ujjwal,
Thanks for response. Declareindex name is IndexWorkGroupInOrgChart.
Can you let me know can we disable this index .
Thanks,
Deva