What is partitioning?

Split a large table into pieces.

What is a partition?

A partition splits a large table into pieces. Each piece is stored separately.

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

Partition by date.

The table sales is created.

Partitioning improves query performance. Only relevant pieces are scanned.

For example, if you partition sales by year, a 2026 report reads only the 2026 partition; older years are never scanned.

Partition the sales table with PARTITION BY RANGE (sale_date).

Show example solution

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

Add PARTITION BY

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

Show answer

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