本文介绍了如何使用SQL创建分区函数及分区方案，并演示了如何通过ALTER命令调整分区配置，包括合并与新增分区范围，以及如何指定新的文件组用于存储分区数据。
CREATE PARTITION FUNCTION [UserRange]
(int) AS RANGE RIGHT FOR VALUES
(1000,1100)
go
CREATE PARTITION SCHEME [UserScheme]
AS PARTITION [UserRange]
TO ([User01], [User02],[PRIMARY])
-- 删除一个点
ALTER PARTITION FUNCTION
[UserRange]()
MERGE RANGE ('1100')
-- 增加一个点
ALTER PARTITION FUNCTION
[UserRange]()
SPLIT RANGE ('1200')
GO
-- 在最后增加一个文件组
ALTER PARTITION SCHEME [UserScheme124]
NEXT USED [User03]
GO
-- 查找一条记录在那个分区
select $partition.[UserRange](id),userid FROM usertable where userid = 1000120
SELECT *, $PARTITION.[Data Partition Range](ID) FROM MyTable
(int) AS RANGE RIGHT FOR VALUES
(1000,1100)
go
CREATE PARTITION SCHEME [UserScheme]
AS PARTITION [UserRange]
TO ([User01], [User02],[PRIMARY])
-- 删除一个点
ALTER PARTITION FUNCTION
[UserRange]()
MERGE RANGE ('1100')
-- 增加一个点
ALTER PARTITION FUNCTION
[UserRange]()
SPLIT RANGE ('1200')
GO
-- 在最后增加一个文件组
ALTER PARTITION SCHEME [UserScheme124]
NEXT USED [User03]
GO
-- 查找一条记录在那个分区
select $partition.[UserRange](id),userid FROM usertable where userid = 1000120
SELECT *, $PARTITION.[Data Partition Range](ID) FROM MyTable
扫一扫
893
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
