Question

1
Replies
327
Views
DevndrV1 Member since 2017 1 post
CVS
Posted: 1 year ago
Last activity: 1 year 11 months ago
Closed

Index creation on operator skills and work table

Hi All,

We got recommendation from our DBA to create indexes on below two tables. Can you please let me know if there any negative impact on performance?

1) Index on work table

Add INDEX on Pega work table on pxCoverInskey to help in a report definition where we have to show al the child work objects of a cover

Index - ("PXCOVERINSKEY" ASC, "PXOBJCLASS" ASC, "PZINSKEY" ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS

2) Index on PR_INDEX_OPERATORSKILLS table

CREATE INDEX “PR_INDEX_OPERATORSKILLS" ("PYUSERIDENTIFIER" ASC, "PXSKILLRATING" ASC, "PXSKILLNAME" ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS;

Regards,
Devndr Verma

***Edited by Moderator Marissa to update SR Details***

Pega Platform System Administration Data Integration SR Exists
Moderation Team has archived post
Share this page LinkedIn