Are there any recommendations for indexing a table with a very high churn rate?
I have a table (in an inherited DB) that is basically used for processing temporary data.
There is a service constantly running that populates this table (200,000-400,000 inserts per day).
There are a number of services running that retrieve and use the data. They flag the data as processed. (200,000-400,000 updates per day).
There is also an additional service that deletes old processed data from the table. (200,000-400,000 deletes per day).
There are indexes on the table but because of the high data churn rate, they are always completely fragmented. They are probably causing more harm than good.
So are there any recommendations for indexing on tables with such high insert, update, delete and read activity?