Re:Cost of a Join
by eximius on Tuesday August 14, 2018 @10:06PM
(#17763303)
Does an enum have any performance or consistency benefits over 1 or 3? (I discount 2 because it seems like the worst possible option.)
It would seem like 1 is essentially an ad hoc enum with the same guarantees and 3 is just a bit easier to use as you can have the enum defined in your code rather than SQL.
It would seem like 1 is essentially an ad hoc enum with the same guarantees and 3 is just a bit easier to use as you can have the enum defined in your code rather than SQL.