Question

1
Replies
84
Views
Close popover
GopiKrishna V (GopiKrishnaV)
HCL
Senior Technical Lead
HCL
AU
GopiKrishnaV Member since 2013 4 posts
HCL
Posted: February 18, 2016
Last activity: February 18, 2016
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,
Close popover 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.