Question

2
Replies
62
Views
Deva_Prathapaneni Member since 2014 30 posts
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***

Low-Code App Development Data Integration
Moderation Team has archived post
Share this page LinkedIn