SQL Server Performance Forum – Threads Archive
Import into a table with/without an ID fieldWhat’s the effect of having an ID field in a table that is being used for a large amount of data import? Does it optimize the process? CanadaDBA
Why should it? See if this helps:http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx —
Microsoft SQL Server MVP
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)
It wouldn’t help performance, the purpose would be to have a unique id or surrogate key.
True it will not help in performance gain, but to keep the consistency of data. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.