That's exactly my situation. I have a historical table and a latest table, and would much rather combine them into one. But then my "latest" queries will "suffer"...
Thanks for the feedback. The table seems to be properly indexed -- we have neither reading nor writing issues w.r.t. query plans or performance. Also, the number of...