Doesn't seem likely. Is it actual execution time that seems longer with
UNION ALL or is it the time it takes to actually deliver the output to you?
With UNION ALL, you should start seeing fetched rows much sooner than with
UNION, but if there are a lot of duplicates, then UNION may complete its
delivery of output to you much sooner.
"Roman Zarzecki" <rzarzecki_at_gis.com.pl> wrote in message
news:83qs83$2nv0$1_at_news.ipartners.pl...
> Sorry if this was previously discussed.
>
> Is it possible that union all takes more time to execute than union
> (distinct) ? I have noticed such a behaviuor on ORACLE 8.0.5
>
>
>
Received on Sat Dec 25 1999 - 01:35:25 CST
