Skip to main content

Range & List Partitioning

Learn Range & List Partitioning (Partitioning, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction RANGE partitioning assigns rows to partitions by which interval the expression falls in (dates, ids). LIST assigns by explicit value sets (region codes, status ids). RANGE COLUMNS and LIST COLUMNS allow non-integer columns directly such as DATE or strings.

More lessons in Partitioning