Question1Replies746Views DyanG412 Member since 2013 212 posts Hawaii Medical Service Association Posted: 3 years agoLast activity: 3 years 7 months ago Closed Solved Optimize Schema Wizard to create indexAn 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 popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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: 3 years agoSantanu PEGA replied to DyanG412The 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.