Thank you guys for all your suggestions. Yes, the column format is YYYYMM. I will add a clustered index on transaction month. I was thinking about filtered Index where month...

Thanks for the feedback. Looks like the advice is to create index on transaction date column. Question ?

1) Should I create clustered or nonclusterd Index. I understand their differenc between...

Thanks Folks. Some info.

Table currently has no clustered or non clustered Index. It has some FK constraints for the tables used in joins. Also, I can't delete old months data....