Partition in Sybase

Is it possible that two tasks be assigned to the similar Partition in Sybase?

E

Expert

Verified

Yes, it is possible that the two tasks be assigned to the similar Partition in Sybase. ASE arbitrarily assigns partitions. This means that there is always a chance that the two users will vie for the similar partition when attempting to insert and one would lock the other out.

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

   Related Questions in Database Management System