Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Devndr Verma (DevndrV1)
CVS

CVS
US
DevndrV1 Member since 2017 1 post
CVS
Posted: Sep 28, 2018
Last activity: Oct 29, 2018
Posted: 28 Sep 2018 14:42 EDT
Last activity: 29 Oct 2018 11:34 EDT
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***

To see attachments, please log in.
Pega Platform
System Administration
Data Integration
Support Case Exists

Posted: 6 years ago
Posted: 1 Oct 2018 3:21 EDT
Marc Lasserre (MarcLasserre_GCS)
PEGA
Technical Account Manager
Pegasystems Inc.
FR

Hello,

I don't think indexes could have negative impact on performance. In general I would follow DBA instructions I think.

To see attachments, please log in.
  • manikanta naveen nallajeru Mani Chalasani

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice