… shows MySQL performance when you use 3 different approaches: ENUM, VARCHAR and tinyint (+joined table) columns. In practice you can also often… with ENUM being fastest and VARCHAR few percent slower. This may look counterintuitive because table is significantly smaller with ENUM or TINYINT but…

