Yes all databases will use indexes for joins. There's quite a few mistakes like that. My guess is the author heard something about not using implicit inner joi

Yes all databases will use indexes for joins. There's quite a few mistakes like that. My guess is the author heard something about not using implicit inner joins (deprecated decades ago) and misunderstood. E.g. This old syntax- SELECT * FROM a, b WHERE a.id = b. a_id