Joins will result in bigger table, increasing the size...
applymap will just fetch values from one table to another, applymap will work like lookup just adding one column to what is already existing but join will join both the tables so the number of lines will increase(not actually what was there in the first table alone)
