SQL Server Performance

identity field

Discussion in 'T-SQL Performance Tuning for Developers' started by pisman, Dec 16, 2004.

  1. pisman New Member

    Hi,

    Is there a difference in performance, when inserting a record, between two tables with identitical fields, except for an identity field. I presume that it would take longer to insert a record in a table with an identity field, since it has to find the last record inserted.

    I'd appreciate any comments on the matter, if possible the amount of difference.
    Thanks in advance
  2. mmarovic Active Member

    It doesn't have to find the last record inserted. It has last identity value used for specific column stored internaly, so it just increment internal counter and use it as a value for identity column.
  3. Twan New Member

    as hinted at by mmarovic, there is no difference in performance

    Cheers
    Twan

Share This Page