You can partition data horizontally based on age 您可以基于年代水平地对数据进行分区。
Views can also be used when you copy data to and from microsoft sql server 2005 to improve performance and to partition data 还可以在向microsoft sql server 2005复制数据和从其中复制数据时使用视图,以便提高性能并对数据进行分区。
When you partition data across multiple servers , queries accessing only a fraction of the data can run faster because there is less data to scan 跨多个服务器对数据进行分区时,只访问一部分数据的查询可以较快地运行,因为只需扫描较少的数据。