DBA > Job Interview Questions > Sybase Interview Questions and Answers

How Does Partition Assignment Relate to Transact

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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.

(Continued on next question...)

Other Job Interview Questions