A simple example ...
create partition function partition_function (int) as range right for values (10000,20000,30000);
create partition scheme partition_scheme
as partition partition_function to (part1, part2, part3, part4);
create table employee (
empID int,
empName varchar(50)) on partition_scheme (empID)
Then employee 20000 ends up in part3 ...
No comments:
Post a Comment