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

 GopiKrishna V (GopiKrishnaV)
HCL
Senior Technical Lead
HCL
AU
GopiKrishnaV Member since 2013 4 posts
HCL
Posted: Feb 18, 2016
Last activity: Feb 18, 2016
Posted: 18 Feb 2016 20:15 EST
Last activity: 18 Feb 2016 20:52 EST
Closed

Hi, Creating new index to COMPLAINT_WORK (Copy of PC_WORK)


Hi Team,

My DB team suggested to create below index on PC-WORK table,

create index complaints_work_idx on complaints_work (caseownerid, pystatuswork, pxobjclass)

Could yo uplease suggest what is the impact on creating new index on PEGA table.

Queries:

1. Required to take a back up before creating index?

2. Is there any PRE or POST activities required to do while creating index (or just running above script in DB is enough)?

FYI,

PEGA Version: 5.5

REcords in Complaints_Work - 3443275

Thanks & REgards,

Gopi

To see attachments, please log in.
System Administration
Data Integration

Posted: 8 years ago
Posted: 18 Feb 2016 20:52 EST
Kevin Zheng (KevinZheng_GCS)
PEGA
Director, Technical Support
Pegasystems Inc.
US

1. no

2. not much I can think of except carefully monitor your system performance especially queries against this table. Your DBA suggests index for a reason, presumably speed up data lookup, but in general it could hinder insertion/updates.

FYI, your version is really old, consider upgrade to pega 7 in the future. I did not find any index for pc_work in the latest release of pega 7.2.

To see attachments, please log in.

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