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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Problem with complicated select process.

Re: Problem with complicated select process.

From: Eric Nordstrom <nordstrm_at_GDSTECH.GRUMMAN.COM>
Date: Sun, 19 Mar 1995 15:55:41 -0500
Message-Id: <9503192239.AA31021@alice.jcc.com> 





Sorry I don't have time to study your problem, but I have found that
UNION ALL is a much better performer than UNION.  UNION will eliminate
duplicate rows and takes a lot of time.  Go with UNION ALL if you can.



Eric Nordstrom


Northrop Grumman Corporation


nordstrm_at_gdstech.grumman.com

Received on Sun Mar 19 1995 - 17:39:40 CST












Original text of this message













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