From owner-oracle-l@CCVM.SUNYSB.EDU Sun Mar 19 17:39:40 1995 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65/1.1.8.2/01Aug94-0142PM) id AA31021; Sun, 19 Mar 1995 17:39:30 -0500 Message-Id: <9503192239.AA31021@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by CCVM.sunysb.edu (IBM VM SMTP V2R2) with BSMTP id 7642; Sun, 19 Mar 95 17:13:33 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 8201; Sun, 19 Mar 1995 15:55:41 -0500 Date: Sun, 19 Mar 1995 15:55:41 -0500 Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: Eric Nordstrom Subject: Re: Problem with complicated select process. X-To: ORACLE-L@ccvm.sunysb.edu To: Multiple recipients of list ORACLE-L X-Orig-Date: Fri, 17 Mar 1995 08:59:57 EST 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@gdstech.grumman.com