Is it better to have a field
status enum('active', 'hidden', 'deleted') OR
status tinyint(3) with a lookup table. Assume that status can take only one value at a time.
In particular, I am interested in knowing, are operations on
enum significantly slower than or as fast as operations on
There is a related question on SO Mysql: enum confusion but
i) It does not discuss performance at all
ii) There is very little explanation on WHY one approach is better than the other.
© Stack Overflow or respective owner