Summary - Partitioning

Build a monthly event table with range partitioning.

Partitioning splits a table: RANGE by range, LIST by value, HASH by hash. Pruning speeds up.

CREATE TABLE sales (...) PARTITION BY RANGE (sale_date);

Summary partitioning query.

The table sales is created.

Exercise Summary - Partitioning

Summary: partition the sales table with RANGE.

Show example solution

CREATE TABLE sales (id INT, sale_date DATE, amount DECIMAL)
PARTITION BY RANGE (sale_date);