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:http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
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
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>