Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UNION or UNION ALL - which faster

Re: UNION or UNION ALL - which faster

From: Russ Fleming <rfleming_at_jaredgroup.com>
Date: 2000/03/25
Message-ID: <ap9D4.1$Hr4.1320@news1.onlynews.com>#1/1

UNION ALL is not supposed to reconcile its result set with other result sets in the union so theoretically it
is supposed to be faster than UNION.

If your relying on UNION to eliminate the dups perhaps you should look more closely at the sql design. Received on Sat Mar 25 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US