UNION vs UNION ALL
From: Danny Roosens <roosens>
Date: 1996/08/28
Message-ID: <5026mq$2u3k_at_news-s01.ny.us.ibm.net>#1/1
Date: 1996/08/28
Message-ID: <5026mq$2u3k_at_news-s01.ny.us.ibm.net>#1/1
Hi,
is it fair to say that one should use
'UNION ALL' as default
and use 'UNION' only when duplicates are expected and not wanted
because it's faster. Received on Wed Aug 28 1996 - 00:00:00 CEST