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

They don't help with that either.

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