When I use an
ENUM column in a table the
ORDER BY uses the ordinal of the
ENUM not its value. I wasn't aware of that.
So my question is what are the subtle issues when an
ENUM is part of an index definition? Is it an antipattern or bad idea?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community