As of now, there are several nonclustered indices placed on the fact table. (these were built to help improve the querying of the BO reports) We do have several surrogate keys in the table as well. We rebuild this fact table (along with other dim, staging, etc.) every night becuase the data in these source tables are updated on a daily basis. So in order to show the updated data in the BO reports, we do this.

The entire process of deleting records, dropping indices, loading data, rebuilding indices takes roughly 3 1/2 hours each night. I would really like to try to cut this in half.