> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/server-usage/partitioning-tables/partitioning-types/partitioning-types-overview.md).

# Partitioning Types Overview

A partitioning type determines how a partitioned table's rows are distributed across partitions. Some partition types require the user to specify a partitioning expression that determines in which partition a row are stored.

The size of individual partitions depends on the partitioning type. Read and write performance are affected by the partitioning expression. Therefore, these choices should be made carefully.

## Partitioning Types

MariaDB supports the following partitioning types:

* [RANGE](/docs/server/server-usage/partitioning-tables/partitioning-types/range-partitioning-type.md)
* [LIST](/docs/server/server-usage/partitioning-tables/partitioning-types/list-partitioning-type.md)
* [RANGE COLUMNS and LIST COLUMNS](/docs/server/server-usage/partitioning-tables/partitioning-types/range-columns-and-list-columns-partitioning-types.md)
* [HASH](/docs/server/server-usage/partitioning-tables/partitioning-types/hash-partitioning-type.md)
* [LINEAR HASH](/docs/server/server-usage/partitioning-tables/partitioning-types/linear-hash-partitioning-type.md)
* [KEY](/docs/server/server-usage/partitioning-tables/partitioning-types/key-partitioning-type.md)
* [LINEAR KEY](/docs/server/server-usage/partitioning-tables/partitioning-types/linear-key-partitioning-type.md)
* [SYSTEM\_TIME](/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables.md)

## See Also

* [Partitioning Overview](/docs/server/server-usage/partitioning-tables/partitioning-overview.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}