MySQL used the index on the joined table, but didn't use an index on the primary table because there isn't anything to filter on. The join condition would still

MySQL used the index on the joined table, but didn't use an index on the primary table because there isn't anything to filter on. The join condition would still cause one table to require a table scan to gather all of the records.