Import into a table with/without an ID field | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Import into a table with/without an ID field

What’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:
Frank Kalis
Microsoft SQL Server MVP
Ich unterstütze PASS Deutschland e.V.

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.