How partitions address page contention

When a transaction inserts data into a partitioned heap table, Adaptive Server randomly assigns the transaction to one of the table’s partitions. Concurrent inserts are less likely to block, since multiple last pages are available for inserts.