Creating a Partitioned Table是干什么用的?
大概用法是
第一步(Creating a Partition Function)
CREATE ARTITION FUNCTION RateChngDate (datetime)
AS RANGE RIGHT FOR VALUES('1996-01-01','2000-01-01')
第二步(Creating a Partition Scheme)
数据库-->属性-->文件组-->新建(Old,First,Second,Third,Fourth五个)-->文件-->新建(Old,First,Second,Third,Fourth与文件组新建对应)
CREATE PARTITION SCHEME RateChngDate
AS PARTITION RateChngDate
TO(Old,First,Second,Third,Fourth)
第三步(Creating a Table by using the partition scheme)
CREATE TABLE HumanResources.EmployeeLeave
(
.......
..
LeaveReason DSCRP,
) ON RateChngDate(RateChngDate)