… Â Â | NULL | 549252 | Using where; Using filesort | +—-+————-+——-+——-+—————+——+———+——+——–+—————————–+ This query took more than 5 minutes (… optimal. We do not really need separate subselect to make MySQL check WHERE clause while …
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
… (selects in FROM clause) are used. MySQL will execute these subselects on explain to provide plan for top most statement, so… catches possibly complex queries it can give you head ache. filesort, using temporary are always in the first line So it… disk for sort or temporary tables MySQL always calls it “filesort” even if it is done in memory. Also it would…
