Illustrates two tasks to be assigned in Sybase

Question

Illustrates the two tasks to be assigned to similar partition in Sybase?

Answer 1

Yes. ASE randomly assigns partitions. This means there is all the time an option that two users will compete for the same partition when attempting to insert and one would lock the other out.

The more partitions a table consist of, the lower the probability of users trying to write to the same partition at the same time.