@jeremybowers this trick worked for me sometimes slow: SELECT * FROM foo WHERE x JOIN bar ON ... fast: SELECT * FROM ( SELECT * FROM foo WHERE x) foo JOIN bar ON ...