We can use the ANALYZE TABLE statement to review and store the key distribution in a table. MySQL stores this information and uses it to decide how to execute joins. You can run this statement by typing
analyze table tablename ;