SQL Server 2005 创建分区应用

1 建分区函数

CREATE  PARTITION  FUNCTION   [ pf_Product_Partition ] ( VARCHAR ( 10 ))  AS  RANGE 
RIGHT
FOR   VALUES  (N ' BigScreen ' , N ' Computer ' , N ' PoolTable ' )

 

CREATE  PARTITION SCHEME  [ ps_Product_Scheme ]   AS  PARTITION
[ pf_Product_Partition ]
ALL   TO  ( [ PRIMARY ] )
' 这里只分了一个区

3 建表，把需要分区的字段关联到分区方案schema上

 

CREATE   TABLE   [ SalesHistoryArchive ]  
(           
        [ SaleID ]   [ int ]   IDENTITY ( 1 , 1 ),           
        [ Product ]   [ varchar ] ( 10 )  NULL ,                 
        [ SaleDate ]   [ datetime ]   NULL ,                 
        [ SalePrice ]   [ money ]   NULL
) ON   [ ps_Product_Scheme ] (Product) 
GO  

--4 创建分区索引
--CREATE INDEX PARTITION_INDEX ON SalesHistoryArchive(Product) ON [ps_Product_Scheme](Product)

5 查看分区数据

6.看每个分区的记录数

SELECT   *   From  sys.partitions
WHERE   OBJECT_NAME ( object_id )  =   ' SalesHistoryArchive '

SELECT   *   From  sys.partitions
WHERE   OBJECT_NAME ( object_id )  =   ' SalesHistoryArchive '

  2 建分区方案，用于与上面的function关联