I am curious about one thing though: Why would it not be a good idea to use multiple tables?
I think that your proposal and Michael's proposal were quite similar. Michael was observing that if you went one step further, and put the multiple tables into multiple databases on multiple machines, then your application could execute the queries against the various table "pieces" in parallel, and get a shorter elapsed time for the overall query.
thanks, bryan
