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

UNION or UNION ALL - which faster

From: my <mohamed.yusuf_at_sympatico.ca>
Date: Sat, 25 Mar 2000 13:38:42 GMT
Message-ID: <Cj3D4.8701$n03.403288@news20.bellglobal.com> 





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 - 07:38:42 CST












Original text of this message













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