Re: Subqueries too slow

[Jay Pipes]

There's no need for subqueries at all. Just use standard joins:

SELECT a.id, a.acc, a.name
FROM a
INNER JOIN b
ON a.id = b.a_id
INNER JOIN c
ON b.c_id=c.id
AND c.acc="X"
INNER JOIN c2
ON b.c_id=c2.id
WHERE c2.acc="Y";

I have, however, reported this to the optimizer team, as they are looking for areas to improve subquery performance... Thanks!

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com