0

Why Union All is faster than Union?

14th Sep 2016, 2:21 PM
Meida Dwi K
Meida Dwi K - avatar
2 Antworten
+ 1
Because UNION ALL doesn't remove duplicate rows.
14th Sep 2016, 2:33 PM
Zen
Zen - avatar
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.
17th Sep 2016, 9:22 PM
vicken bedikian
vicken bedikian - avatar