In round-robin partitioning, Adaptive Server does not use partitioning criteria. Round-robin-partitioned tables have no partition key. 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.
Round-robin partitioning is supported primarily for compatibility with versions of Adaptive Server earlier than 15.0. 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
