Jerry, On Wed, May 26, 2010 at 5:13 PM, Jerry Schwartz <je...@gii.co.jp> wrote: > I have a pretty simple query that seems to take a lot longer than it ought to > (over 2 minutes). >
I suspect that if you watch Handler_ stats, you'll find that the EXPLAIN estimate is wrong for some reason and it's accessing many more rows than you think in the second table, or something similar. In any case, I'd start by measuring what the query is actually doing, not what EXPLAIN thinks. What does that show? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
