Skip to main content
Contact a Moderator

Question

1
Replies
756
Views
 Dyan Baur (DyanG412)
Hawaii Medical Service Association

Hawaii Medical Service Association
US
DyanG412 Member since 2013 212 posts
Hawaii Medical Service Association
Posted: March 14, 2017
Last activity: March 14, 2017
Posted: 14 Mar 2017 1:54 EDT
Last activity: 14 Mar 2017 11:53 EDT
Closed
Solved

Optimize Schema Wizard to create index

An index can be created for a column in dev environment via Optimize Schema wizard. Is it recommended to use the Optimize Schema Wizard in other environments like in pre prod, and prod environments?

Data Integration
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.

Accepted Solution

Posted: 4 years ago
Posted: 14 Mar 2017 9:57 EDT
Santanu Bhattacherjee (Santanu)
PEGA
Senior Manager - Sales Automation
Pegasystems Inc.
IN

The main purpose of schema optimization is to improve performance. Hence i think it is ok to use it in higher environment.


However , it is always recommended to consult your Project LSA and DBA once before carry out such operation in Prod.

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