Question1Replies348Views×Close popoverDevndr Verma (DevndrV1) CVS CVS US View Profile DevndrV1 Member since 2017 1 post CVS Posted: September 28, 2018Last activity: October 29, 2018Posted: 28 Sep 2018 14:42 EDTLast activity: 29 Oct 2018 11:34 EDT 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: 2 years agoPosted: 1 Oct 2018 3:21 EDT×Close popoverMarc Lasserre (MarcLasserre_GCS) PEGA Principal Software Solutions Engineer PEG FR View ProfileMarcLasserre_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.