Sybase Question:
Download Questions PDF

How Does Partition Assignment Relate to Transactions in Sybase?


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.

Download Sybase Interview Questions And Answers PDF

Previous QuestionNext 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?