Data gets read in every quarter into this table. Then after it is read in, certain fields get updated through an update command. The updates run really fast on the previous quarter's data, but when it gets to the new data it takes a long time.
We solved the problem by rebuilding the primary key after data is read in, and then running the update commands. This makes it just as fast as previous quarters but the rebuild can take a long time.
When I rebuild the indexes, we started using a fill factor but that did not help the cause.
Is there anything else I should consider?