I'm building a table to store files from a trading partner. This table will be used to stage the data where it is transformed and moved to a separate database. My thought is to use a bit column 'IsActive' to designate which rows a currently in the queue vs which have been previously processed. I expect this table to grow ~5000 rows per day. I'm not sure an index would be best because to my understanding, they are best when applied to columns with many distinct values, the 'IsActive' column will only have 2 values. My next thought was to use horizontal partitioning. I've never used it before, so I thought I would see if you all had any recommendations.