Should I have a dedicated primary key field?

by

I would use a generated PK myself, just for the reasons you mentioned. Also, indexing and comparing by integer is faster than comparing by strings. You can put a unique index on the name field too without making it a primary key.

More Related Contents:

  1. Why use multiple columns as primary keys (composite primary key)
  2. How to design a product table for many kinds of product where each product has many parameters
  3. What is Normalisation (or Normalization)? [closed]
  4. What are the best practices for using a GUID as a primary key, specifically regarding performance? [closed]
  5. Database design – articles, blog posts, photos, stories
  6. Schema for a multilanguage database
  7. Can I have multiple primary keys in a single table?
  8. Calendar Recurring/Repeating Events – Best Storage Method
  9. How to version control a record in a database [closed]
  10. designing database to hold different metadata information
  11. Same data from different entities in Database – Best Practice – Phone numbers example
  12. Sql – Indirect Foreign Key
  13. What are the lengths of Location Coordinates, latitude and longitude? [closed]
  14. Remove Primary Key in MySQL
  15. How should I implement this schema in MongoDB?
  16. How do you deal with polymorphism in a database?
  17. Nullable Foreign Key bad practice?
  18. How do I design a database to store properties, selecting attributes by synonyms
  19. Composite primary key or not?
  20. Can we create multicolumn unique indexes on MS access databases?
  21. Strings as Primary Keys in MYSQL Database [closed]
  22. Database design for audit logging [closed]
  23. Should I use a single or multiple database setup for a multi-client application? [closed]
  24. Database Design Best Practices [closed]
  25. Composite PRIMARY KEY enforces NOT NULL constraints on involved columns
  26. A column as primary key or two foreign keys as primary key
  27. Bill of materials database model
  28. How to choose the clustered index in SQL Server?
  29. What are design patterns to support custom fields in an application?
  30. mongodb schema design for blogs

Leave a Comment