Sybase Question: Download Questions PDF
Can Two Tasks Be Assigned to the Same Partition in Sybase?
Answer:
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.
The more partitions a table has, the lower the probability of users trying to write to the same partition at the same time.
Download Sybase Interview Questions And Answers
PDF
Previous Question | Next Question |
Must I Use Multiple Devices to Take Advantage of Partitions in Sybase? | How Does Partition Assignment Relate to Transactions in Sybase? |