Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PARTITION FUNCTION px_age(INT) AS RANGE RIGHT
- FOR VALUES(25,50,100)
- CREATE PARTITION SCHEME px_ageScheme AS PARTITION px_age ALL TO ( SECONDARY )
- CREATE TABLE usr_ages
- ( ID SMALLINT ,name VARCHAR(50), age INT) ON px_ageScheme(age);
- GO
- CREATE clustered INDEX idx_teste
- ON usr_ages(id);
- DECLARE @i AS tinyint = 0;
- WHILE @i <= 128
- BEGIN
- INSERT INTO usr_ages VALUES(@i,'Tiago :)',@i);
- SET @i = @i +1;
- END
- -- MAX on table is 128, SPLITTING on 130 doesn't do any data movement
- ALTER PARTITION FUNCTION px_age()
- SPLIT RANGE(130);
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement