Partition by range

- [Instructor] Let's look at range partitioning. … Range partitioning is a kind of horizontal partitioning. … Partitions are created using a partition key, … such as a date when partitioning by time. … But a numeric or alphabetic range may also be used. … The partition key is a column used to determine … which partition should hold a row. … Now partitions are bounded, … and they're bounded by minimum and maximum values … on the partition key. … Now since partitions are like separate tables … each partition can have its own indexes, … constraints, defaults, et cetera. … Let's look at an internet of things, or IoT example. … In this example we're collecting measurements. … Now each measurement has a location, a date, … a temperature, and a relative humidity. … The partition key is the date … that the measurement was taken. … Now we can partition this table into week-long partitions. … Here we create one partition for each week. … The range of values of the partition key … span one week in each partition. …