[gaius]

Errm, we're talking about performance of joins

[ComputerGuru]

Joins will use the regular index matching it against the join condition just like a where clause would.

[kondro]

They don't help with that either.

[Sacho]

Perhaps parent is conflating indexes with constraints? I believe InnoDB creates indexes automatically with foreign keys.