Partitioning types and expressions

The partitioning is based on a value that is calculated for each row using a partitioning expression. The partitioning type is a method that is used to assign each row to a particular partition based on the partitioning expression. For example, the RANGE type assigns a range of values to each partition. When a row is inserted, its partitioning expression is calculated. The row will be written into the partition that matches the proper range.

Partitioning expressions

A partitioning expression is a SQL expression that returns a positive integer value or NULL. It is possible to use a temporal column in the partitioned expression as long as an integer value is returned. However, the return value cannot depend on the ...

Get Mastering MariaDB now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.