0
Why Union All is faster than Union?
2 odpowiedzi
+ 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.