Wow, yeah, for sure
cluster by DateSent if that's the case. The other conditions won't matter.
Btw, the other tables I was worried about being scanned, I had more time to look, and they are small anyway, so a scan on those doesn't matter (at least for now).
I'm not clear on the indexes i should end up with. No primary key, just a clustered index on DateSent?