Question
Range versus list partitioning: how do their bounds differ, and when should each be used?
Answer
Range partitions define non-overlapping intervals, with inclusive lower and exclusive upper bounds. List partitions define explicit discrete values. Use range for time or ordered keys; use list for known categories, tenants, or regions.