If you look at the ODI code base for OBIA (all 11.X versions) before every SDE mapping step or SIL mapping steps. We will see two sets of steps. Initialize steps (Before the map is run) Indexes are dropped Finalize steps (After the map is run) Indexes are created Stats are gathered When we add a new index to a table in DW schema or when we delete an index, we do not have to add CREATE INDEX, DROP INDEX or GATHER STATS steps to the ODI code base. There are hooks in the code to take care of these steps irrespective of the number of indexes. Index maintenance steps can be achieved by a couple of simple steps in Designer without having to write a single line of code. Let's start by understanding what are the steps involved in adding an index to a table. Step 1: Create indexes on the database Step 2: Reverse engineer the model (typically named Oracle BI Applications) Customized Reverse-Engineering using OBIA specific RKM Step 3: Modify options on the index....