10 – Table Partitioning by Date Range

Theory

RANGE partitioning by `createdat`

Benefits

Limitations

Default partition

Task

Full Working Code

SQL Setup

`src/test/java/com/example/demo/repository/PartitioningTest.java`

Expected Output

EXPLAIN without filter (all partitions scanned):

EXPLAIN with filter (partition pruning):

Partition hierarchy:

Sub-partitions:

Verification Steps