0
Why Union All is faster than Union?
2 Answers
+ 1
Because UNION ALL doesn't remove duplicate rows.
0
like Zen said,union all gives u everything without modification , reducing processing time, whereas union checks and removes duplicates,therefore using more CPU power.
Often have questions like this?
Learn more efficiently, for free:
