Tutorial by Topics: partitioning

Partitioning is a functionality to split tables and indexes into smaller pieces. It is used to improve performance and to manage the smaller pieces individually. The partition key is a column or a set of columns that defines in which partition each row is going to be stored. Partitioning Overview ...

RANGE partitioning. This type of partitioning assigns rows to partitions based on column values falling within a given range. LIST partitioning. Similar to partitioning by RANGE, except that the partition is selected based on columns matching one of a set of discrete values. HASH pa...