New course! Every coder should learn Generative AI!
Try a free lesson0
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.