€19.09 – €22.30
Logic Breakdown
- Partition Key:
transaction_date
is used as the partition key to group rows logically based on the date range.
- Primary Key Adjustment:
- Include
transaction_date
in the primary key to support partitioning constraints.
- Include
- Defined Ranges:
- Each
VALUES LESS THAN
clause specifies the upper boundary for a partition. Rows withtransaction_date
values up to the defined limit are stored in the respective partition.
- Each
- Default Partition:
- The
p_max
partition captures records with dates not falling into defined ranges.
- The