I read a lot of articles about ENUM. but most of them are comparing ENUM to joins not tinyint.

I need fields with 2-5 different statuses. In this situation is there any performance or storage benefit or drawback of using ENUM?

  • 1
    I think the answer is "No". Anyway when processing the query ENUM is treated as SMALLINT UNSIGNED (except compare - in that case the string-type compare may decrease performance). And what's a profit? minus 1 small table? – Akina Jul 18 '18 at 5:26
  • There have been several Q&A on the ENUM vs TINYINT vs VARCHAR in stackoverflow.com – Rick James Jul 18 '18 at 6:13
  • The performance difference is insignificant. The coding difference may be worth picking one over the other. – Rick James Jul 18 '18 at 6:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.