My clustered index is on the year first then the account number.
Sounds like year, month and date are stored in separate columns.
If that's the truth, then yes, indexing is not the only cause of the bad performance.
_____________
Code for TallyGenerator