Good post.
You are raising a real topic here.
This Query is just in memory full table scan with thread state transition to make a join.
