Explain advantage of Table Partitioning with bcp in Sybase
Explain the advantage of Table Partitioning with bcp in Sybase?
Expert
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 concurrent jobs raises throughput
2. Select a number of partitions greater than the number of bcp jobs.Having extra partitions than processes (jobs) reduces the probability of page lock contention.
3. Utilize the batch option of bcp in. For illustration, after every 100 rows, force a commit. Now there is the syntax of such command:
bcp table_name in filename -b100
All time a transaction commits, Adaptive Server Enterprise randomly assigns a new partition for the next insert. It, in turn, reduces the probability of page lock contention.
Explain the transformations which are used for the variable port?
Describe in brief regarding the Sybase 365?
Briefly describe the five elements of an Information Systems Architecture and their relationship to data.
Describe briefly the term maximum and minimum cardinality?
Specify different types of transformations available in the Informatica?
What are the difficulties faced by the database developer during implementing pre compiled statements?
Write a short note on the difference between the disjoint and overlap rule.
What are two types of implementation as a centrally located logical architecture? Answer: There two types of implementation are as follows: firstly gives a single ve
Which type of pointer will be use to implement the heterogeneous linked list in C language?
MiniSQL Parser Relax; you don't have to write the parser! On the contrary, a complete parser and type checker for the MiniSQL language is provided with the skeleton code. This small subset of SQL includes the
18,76,764
1956409 Asked
3,689
Active Tutors
1429469
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!