I have tables where the primary key is something like this:
-StoreID
-BusinessDate
Typically, there is one row for every store (~100) for every single day. One row for each store is inserted on a daily basis and is never updated and almost never deleted.
I think is would be better if the field order would be:
-BusinessDate
-StoreID
My reasoning is that the sort order of this key would more naturally follow the typical insert order. I'm wondering if I should change the order of the fields in the key.
So far performance has been acceptable. Will the current field ordering cause serious performance problems in the future if I don't change anything?