… in customers’ application we can see a huge tables with varchar/char fields, with small sets of possible values. These are “state… which shows MySQL performance when you use 3 different approaches: ENUM, VARCHAR and tinyint (+joined table) columns. In practice you can also… close with ENUM being fastest and VARCHAR few percent slower. This may look counterintuitive because table is significantly smaller with ENUM or TINYINT…