I wrote a set of procedures for a previous employer that dropped and recreated the indexes and foreign key references on specified tables that were used before and after the load process into their data warehouse. Since it dynamically captured the index information when run there was no need to maintain drop and create scripts so if a new index was created on a table, it was automagically captured during the next load.