首先，我真的不会根据区域将数据分成几个表。如果你担心性能，请专注于索引和SQL执行计划。



但是，如果你真的需要这样做有充分理由，我建议你你使用分区表。有关详细信息，请参阅分区表和索引 [ ^ ]

First of all, I really wouldn't separate the data into several tables based on the region. If you're worried about performance, concentrate on indexing and the SQL execution plans.

However, if you really need to do this for a good reason, I suggest that you use partitioned tables. For more information, see Partitioned Tables and Indexes[^]