Lynn Pettis (4/19/2010)
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.
I'll try it out and see what the results are. This seems like it might actually give me a performance boost, whereas breaking up the query is almost certainly a performance hit.