Union All versus Distinct Union

Select between keeping duplicate entries or enforcing set uniqueness in merged results.