Illustrates two tasks to be assigned in Sybase

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

E

Expert

Verified

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.

   Related Questions in Database Management System

©TutorsGlobe All rights reserved 2022-2023.