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

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

Re: UNION or UNION ALL - which faster

From: Russ Fleming <rfleming_at_jaredgroup.com>
Date: Sat, 25 Mar 2000 20:34:14 GMT
Message-ID: <ap9D4.1$Hr4.1320@news1.onlynews.com> 





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 - 14:34:14 CST












Original text of this message













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