Tagged: UNION ALL

0

UNION vs UNION ALL

In this post, we will have a look at the differences between UNION and UNION ALL operators using Heap and Clustered Tables. For this illustration, I will use the Adventure Works DW database. UNION – By default UNION does a distinct select on the valuesUNION ALL – Allows the selection...