Mysql - Pay Attention To Columns That Are Used To Join Tables

Pay special attention to columns that are used to join one table to another. They should be indexed for fast lookup, and shorter columns can be compared to each other more quickly. Use the same data type for joined columns because, in general, like types can be compared faster than unlike types. (CHAR and VARCHAR columns that are declared as the same length are the same for comparison purposes.)