In round-robin partitioning, Adaptive Server assigns rows in a round-robin manner to each partition so that each partition contains a more or less equal number of rows and load balancing is achieved. Because there is no partition key, rows are distributed randomly across all partitions.
In addition, round-robin partitioning offers:
Multiple insertion points for future inserts
A way to enhance performance using parallelism
A way to perform administrative tasks, such as updating statistics and truncating data on individual partitions
