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's 100% free, no registration required.
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top