Sometimes we need to JOIN tables using character data types, but the columns may be too large to create an index due to the index size limitations. Read this tip to learn how to use CHECKSUMs to join tables.