>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?