Yes, actually, Jeff and I switched a lot of UNION to UNION ALL clauses for 4.6.? for this very reason, when it was clear that there was no possibility of duplicate rows.
Thanks for the Oracle reference - Oracle's ability to optimize in the face of UNION is rather limited, indeed.
