Joins work fastest if the columns in the join condition have been indexed. In some cases, joining on unindexed columns can result in a slow query. The join columns must be of the same (or compatible) ...