… which shows MySQL performance when you use 3 different approaches: ENUM, VARCHAR and tinyint (+joined table) columns. In practice you can… tables: 1) Table with ENUM: CREATE TABLE cities_enum ( id int(10) unsigned NOT NULL auto_increment, state enum(‘Alabama’,'Alaska’,'Arizona’,'Arkansas’,'California…

In the test you used int+join table, what if we move the join table functionality to our application and just compare ENUM VS CHAR VS INT.