Sybase Question:
Download Questions PDF

How Do I Take Advantage of Table Partitioning with bcp in Sybase?


You can take advantage of table partitioning with bcp in by following these guidelines:

1. Break up the data file into multiple files and simultaneously run each of these files as a separate bcp job against one table.

Running simultaneous jobs increases throughput.
2. Choose a number of partitions greater than the number of bcp jobs.
Having more partitions than processes (jobs) decreases the probability of page lock contention.
3. Use the batch option of bcp in. For example, after every 100 rows, force a commit. Here is the syntax of this command:
bcp table_name in filename -b100
Each time a transaction commits, ASE randomly assigns a new partition for the next insert. This, in turn, reduces the probability of page lock contention

Download Sybase Interview Questions And Answers PDF

Previous QuestionNext Question
How to manually drop a table in Sybase?Why do my page locks not get escalated to a table lock after 200 locks?