Hi;
The MySQL manual states that Joins perform better than subselects. The
stated reason is that the planner can better optimize a join.
I am, however, very skeptical of this, and would generally assume things to
be the other way around.
How do subselects perform in relation to hash joins, etc?
Best Wishes,
Chris Travers