Quote Originally Posted by LKBrwn_DBA
PS: Union all will make no difference unless routes are duplicate.
... other than eliminating an unneccessary sort of the data set, which I'd regard as being pretty important. UNION ALL ought to be the first recourse, and UNION should only be used where there is a specific requirement to make the result set distinct.

Do you roll your eyes at colleagues in meetings? Nice touch.