Re:Cost of a Join
by CuriouslyC on Wednesday August 15, 2018 @10:05AM
(#17766084)
Enums are much easier to deal with in application code, because you don't have to deal with joins and keep track of a separate entity. You could get the same effect using a string pkey, if performance isn't an issue. Enums are also ordered, which can be useful in certain circumstances.
[ Parent
| on HN ]
> Enums are also ordered, which can be useful in certain circumstances.
Are they ordered in a way that's different from an integer value that's a foreign key into another table?
The main difference I can perceive is that the ordering is non-obvious to a human, unlike integers, which seems less useful, not more.