GUID vs INT IDENTITY [duplicate]

by

Kimberley Tripp (SQLSkills.com) has an article on using GUID’s as primary keys. She advices against it because of the unnecessary overhead.

More Related Contents:

  1. What are the performance improvement of Sequential Guid over standard Guid? [closed]
  2. What’s the Hi/Lo algorithm?
  3. Can I have multiple primary keys in a single table?
  4. Surrogate vs. natural/business keys [closed]
  5. Advantages and disadvantages of GUID / UUID database keys
  6. How to retrieve the last autoincremented ID from a SQLite table?
  7. Can we update primary key values of a table?
  8. What are the design criteria for primary keys?
  9. Oracle (ORA-02270) : no matching unique or primary key for this column-list error
  10. Is it fine to have foreign key as primary key?
  11. Deciding between an artificial primary key and a natural key for a Products table
  12. Should a database table always have primary keys?
  13. Should each and every table have a primary key?
  14. When and why are database joins expensive?
  15. Copying data from one SQLite database to another
  16. Can HTML5 databases and localStorage be shared across subdomains?
  17. Relational table naming convention [closed]
  18. What’s the difference between findAndModify and update in MongoDB?
  19. How SID is different from Service name in Oracle tnsnames.ora
  20. What is a sequence (Database)? When would we need it?
  21. Storing Images : DB or File System –
  22. Database optimization orders
  23. In what way does denormalization improve database performance?
  24. have address columns in each table or an address table that is referenced by the other tables?
  25. Minimum no of tables that exists after decomposing relation R into 1NF?
  26. How to unit test an object with database queries
  27. Populate Android Database From CSV file?
  28. Creating test data in a database [closed]
  29. Maximum number of rows in a sqlite table
  30. Mysql service won’t start, InnoDB init function error

Leave a Comment