求相助，mysql查询优化

2012-07-16

求帮助，mysql查询优化SELECT MIN(CV),MAX(CV),COUNT(CV) FROM A INNER JOIN (select C1 FROM B where C2

求帮助，mysql查询优化
SELECT MIN(CV),MAX(CV),COUNT(CV) FROM A INNER JOIN ( select C1 FROM B where C2 = 2010 AND C3 = 4 )B ON A.C1 = B.C1;