Bcp in speed and structure of the table Bcp in our production system in the index could not be deleted Noclustered unique index built on the table Fairly slow, and ask you how to improve bcp in the speed Thank you! Bcp in speed and structure of the table BCP IN Trigger time to delete all the indexing and speed have improved significantly. In particular trigger, even when doing bcp in the table will not trigger a trigger, but they will become very slow speed (relative to the situation and did not trigger) Bcp in speed and structure of the table Limited to the application requirements often can not be deleted bcp in the index, table of bcp district of application. Bcp in speed and structure of the table Table Division table only to avoid competition ;bcp although the last page of a separate district bcp in, but if a table index, even if it will bring more bcp indexing process locks competition, enhance their estimated speed. Under normal circumstances or good points removed Index Bcp in speed and structure of the table In fact, even if we did not delete the index, so when the list is being bcp in the lock, it was impossible to use any other user of the table, whether in the use of the index should not be any distinction deleted. So I suggest you delete the index or after bcp, evidently the only slowly bcp Ps. According to my experience, a few hundreds of thousands of records, delete Index +bcpin+ reconstruction will be far smaller than the index did not delete the index directly bcpin Bcp in speed and structure of the table Try : (Express) Sub used for a number of processes, each consisting of no more than attention to the escalation value chain. Bcp. . . . . . . . . . F 1-b 5000 & -L100000 Bcp. . . . . . . . . . L-F 100001 5000 & 200000-b . . . . [ Closed window ]