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 -> UNION or UNION ALL - which faster

UNION or UNION ALL - which faster

From: my <mohamed.yusuf_at_sympatico.ca>
Date: 2000/03/25
Message-ID: <Cj3D4.8701$n03.403288@news20.bellglobal.com>#1/1 






hi everybody,



I'm hitting 5 tables with millions of records using operator UNION or UNION
ALL. both takes hrs to get the result - I'm not worried since UNION ALL
returns dublicates as well. Can anybody tell me the best way or alternative
ways that makes faster.
Received on Sat Mar 25 2000 - 00:00:00 CST












Original text of this message













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