Physical Database Design

7.4 Administration and Fast Roll-in and Roll-out 131

The keyword “LEFT” implies that each range is defined to the left of the value

specified, such that each value represents the right most (or largest) value in the range.

In this example, four ranges are created: Values <=1, Values <=50, Values <=100, and

values greater than 100.

Following is an example of a partition scheme:

CREATE PARTITION SCHEME myRangePartScheme

AS PARTITION myRangePartFunc

TO (FileGp1, FileGp2, FileGp3, FileGp4);

Finally the range partitioned table is created:

CREATE TABLE Sales (sale_price int, date_of_sale date)

ON myRangePS1 (sale_price) ;

7.4 Administration and Fast Roll-in and Roll-out

Despite the healthy and impressive discussion above about range partitioning and parti-

tion ...