KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Let's say I want to perform this query: (SELECT a FROM t1 WHERE a=10 AND B=1) UNION ALL (SELECT a FROM t2 WHERE a=11 AND B=2) UNION ALL (SELECT a FROM t3 WHERE a=12 AND B=3) ORDER BY a LIMIT 1000; Is MySQL smart enough to skip "t3" if 550 results are available in "t1" and 450 in "t2"? I'm looking at MySQL docs ( http://dev.mysql.com/doc/refman/5.1/en/union.html ) but can't seem to find the answer.
Tags (comma-separated)
Save Edits
Cancel