Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    39

    Unanswered: identity columns

    Hello!
    Can some one provide some guidelines on when to use identity columns, the advantages, pros and cons to consider...etc
    When and how would it be useful to use indentity columns?

    Also..if such a column is used, are there any pitfalls, if uniqueness is enformed on another set of columns in the same table by means of a unique index?

    Thanks in advance.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    the favour is that you don't need to care about primary key values; they are automatically incremented. If you had a table for the high watermarks you may run in (dead)lockings if the hit rate ist high

    for the cons and pitfalls look at rob verschoor's site at http://www.sypron.nl/idgaps.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •