Advertisement
Guest User

Table Partitioning SQL Data Movement

a guest
Jun 17th, 2013
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.55 KB | None | 0 0
  1. CREATE PARTITION FUNCTION px_age(INT) AS RANGE RIGHT
  2. FOR VALUES(25,50,100)
  3.  
  4. CREATE PARTITION SCHEME px_ageScheme AS PARTITION px_age ALL TO ( SECONDARY )
  5.  
  6. CREATE TABLE usr_ages
  7. ( ID SMALLINT ,name VARCHAR(50), age INT) ON px_ageScheme(age);
  8. GO
  9.  
  10. CREATE clustered INDEX idx_teste
  11. ON usr_ages(id);
  12.  
  13. DECLARE @i AS tinyint = 0;
  14. WHILE @i <= 128
  15. BEGIN
  16.     INSERT INTO usr_ages VALUES(@i,'Tiago :)',@i);
  17.     SET @i = @i +1;
  18. END
  19.  
  20. -- MAX on table is 128, SPLITTING on 130 doesn't do any data movement
  21. ALTER PARTITION FUNCTION px_age()
  22. SPLIT RANGE(130);
  23. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement