4. SQL Statements : CREATE TABLE : Partitioned Tables
 
Share this page                  
Partitioned Tables
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:
Only one dimension can be specified.
The distribution type must be HASH.
Only one location per partition is allowed.