A table can be partitioned. Partitioning distributes the rows of a table among a number of sub-tables (partitions). A partitioning scheme determines which rows are sent to which partitions.

After the partitioning scheme is defined, partitioning is managed automatically.

To define a table with partitions, use the PARTITION= option in the CREATE TABLE WITH clause.

When creating tables, NOPARTITION is the default.

Partitioned tables have the following restrictions: