sqlserver表分區

標籤：

 

參考:http://www.cnblogs.com/knowledgesea/p/3696912.html

及百度搜尋sqlserver表分區

 

create partition function sgy_partitionfun (int) as range left for values(N‘10000‘, N‘20000‘)//drop partition function sgy_partitionfunBEGIN TRANSACTION--建立資料分割配置CREATE PARTITION SCHEME [bgPartitionSchema] AS PARTITION sgy_partitionfun TO ([PRIMARY], filegroup1, filegroup2)--建立分區索引CREATE CLUSTERED INDEX [ClusteredIndex_on_bgPartitionSchema_635342971076448165] ON gms_item(    gameserverid)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [bgPartitionSchema](gameserverid)--刪除分區索引DROP INDEX [ClusteredIndex_on_bgPartitionSchema_635342971076448165] ON gms_item WITH ( ONLINE = OFF )COMMIT TRANSACTIONselect * from gms_item where $partition.sgy_partitionfun(gameserverid)=1

　　

sqlserver表分區