List partition
Partitioning strategy: explicit list of values per partition. PARTITION p_emea VALUES IN ('SE','NO','DK','FR','DE'). Use case: regional data sharding, category-based splitting.
Distinct from hash (auto-distribute) and range (boundary-based): list is manual mapping. Use case: regional compliance (EU data in EU partition for GDPR), tenant-tier separation (premium customers one partition, free on another). Performance: efficient pruning for WHERE-clause on partition key. Maintenance: add new value → requires alter partition (add to specific partition or create DEFAULT partition for catch-all). Modern best practice: combine list (for regional) + range (for time-within-region) as multi-level partitioning.