I have read many articles now about natural vs surrogate primary keys, and came to the conclusion there is no single best practice.
I have a table that will have around 2000 definite unique values, each value will range from 5 characters to 40 in length.
This seems like a partial choice as a natural key, although the values which are 40 characters in length may cause some performance and storage issues when they are referenced elsewhere.
As the total maximum rows in this table is fixed as 2000 and 35% of these rows contain value length of 25-40 characters(65% have length 6-25), shall I go with a natural key here?
With your experience, what would you do here?