We are using Oracle Warehouse Builder product to load data into our warehouse. However, we have this huge package that takes 12 hours to load. I am just wondering, for a quick fix, we can replace some of the big tables with materialized view first, during the day, we can insert them into actual tables. Will this help speed up the process if so how much. The other obviouse thing is to index some of the tables. This package is very big, 120 page long. Any other suggestions.