Question

1
Replies
348
Views
Close popover
Devndr Verma (DevndrV1)
CVS

CVS
US
DevndrV1 Member since 2017 1 post
CVS
Posted: September 28, 2018
Last activity: October 29, 2018
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