Sybase Question: Download Questions PDF
How Does Partition Assignment Relate to Transactions in Sybase?
Answer:
A user is assigned to a partition for the duration of a transaction. Assignment of partitions resumes with the first insert in a new transaction. The user holds the lock, and therefore partition, until the transaction ends.
For this reason, if you are inserting a great deal of data, you should batch it into separate jobs, each within its own transaction. See "How Do I Take Advantage of Table Partitioning with bcp in?", for details.
For this reason, if you are inserting a great deal of data, you should batch it into separate jobs, each within its own transaction. See "How Do I Take Advantage of Table Partitioning with bcp in?", for details.
Download Sybase Interview Questions And Answers
PDF
Previous Question | Next Question |
Can Two Tasks Be Assigned to the Same Partition in Sybase? | Can I Run Any Transact-SQL Command on a Partitioned Table in Sybase? |