Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
Clustered index strategy
I have a single table database. The table holds health claims information (service codes and dates, providers, consumers) from another agency. It is updated once a month by inserting ~100k - 200k new rows (it currently has 10 million). Existing rows are never updated. I am going to move it to another server and am trying to figure out the best clustered index.
It seems that any column that would be useful for querys would cause massive page splits, since the data is so diverse for any given month. If I used the month/year paid, it would cause no splits since that is the way the data is sent to us. We do query on (between) service begin and end dates. The claims do come in somewhat in order by those dates.
What does anyone suggest?
TIA
John
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement