Question

1
Replies
83
Views
GopiKrishnaV Member since 2013 3 posts
HCL
Posted: 4 years ago
Last activity: 4 years 7 months ago
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

System Administration Data Integration
Moderation Team has archived post
Share this page LinkedIn