Managing partitions

In this section, we will cover options for managing partitions.

Some options that we will look into are the following:

• RANGE partitioning
• LIST partitioning
• HASH partitioning
• KEY partitioning

RANGE partitioning

Partitioning of this type has an impact on partition records based on the values of columns within a given scope.

The RANGE partition is organized from an interval between two values as long as these values do not overlap, and are set using the VALUES LESS THAN operator.

The basic syntax for creating a partition with RANGE is as follows:

In our following examples, suppose you create a table to store employee records for a pizza chain of 30 restaurants, numbered from 1 to 30.

This table can...