Is JOIN Faster Than Correlated Subqueries? Taking a Look and Subsequently Debunking the Myth

The "bad" correlated subquery outperformed the "good" JOIN. The subquery triggered a Nested Loop plan with fast index lookups (25 quick searches)