Does MySQL index foreign key columns automatically?

database, indexing, mysql

Solution

Yes, but only on innodb. Innodb is currently the only shipped table format that has foreign keys implemented.

Problem

Original source