|
Can Two Tasks Be Assigned to the Same Partition in Sybase?
Sybase Interview Questions and Answers
(Continued from previous question...)
Can Two Tasks Be Assigned to the Same Partition in Sybase?
Yes. ASE randomly assigns partitions. This means there is always a chance that two users will vie for the same partition when attempting to insert and one would lock the other out.
The more partitions a table has, the lower the probability of users trying to write to the same partition at the same time.
(Continued on next question...)
Other Interview Questions
| 