Question 1 Replies 754 Views × Close popover Dyan Baur (DyanG412) Hawaii Medical Service Association Hawaii Medical Service Association US View Profile Send Message 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 × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × 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. Accepted Solution Posted: 4 years ago Posted: 14 Mar 2017 9:57 EDT × Close popover Santanu Bhattacherjee (Santanu) PEGA Manager CRM - Field Service Pegasystems Inc. IN View Profile Send Message Santanu PEGA replied to DyanG412 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.