Hi,
In one of my tables I have a column that is a kind of tracking number for a product. It is the primary key of the table composed of a string of numbers (date+ id product+ id person processing order, etc) that I have defined as a text, because it is too long to be declared as an integer.
- Is a text primary key less efficient than an integer one?
- Is it safer (for database integrity) to have a autonumber primary key?
Thanks very much.