Question
2
Replies
66
Views
Cognizant
Posted: July 6, 2018
Last activity: July 9, 2018
Closed
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***
Posted: 2 years ago
Hi Ujjwal,
Thanks for response. Declareindex name is IndexWorkGroupInOrgChart.
Can you let me know can we disable this index .
Thanks,
Deva
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