>>I know, but you're doing an extra work using UNION as UNION also does distinct. Since in your case you never need a distinct result, you need to use UNION ALL.
>
>So, while both would return the same result, not using UNION ALL would create an overhead on the processing time. Is that correct?

Correct.