Question1Replies327Views DevndrV1 Member since 2017 1 post CVS Posted: 1 year agoLast activity: 1 year 11 months ago Closed Index creation on operator skills and work tableHi 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 tableAdd 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 coverIndex - ("PXCOVERINSKEY" ASC, "PXOBJCLASS" ASC, "PZINSKEY" ASC) ALLOW REVERSE SCANS COLLECT SAMPLED DETAILED STATISTICS2) Index on PR_INDEX_OPERATORSKILLS tableCREATE 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 ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 1 year agoMarcLasserre_GCS PEGA replied to DevndrV1Hello, I don't think indexes could have negative impact on performance. In general I would follow DBA instructions I think.