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 -> Problem with union in Oracle 7.3

Problem with union in Oracle 7.3

From: Hein van Vroonhoven <Hein.vanVroonhoven_at_ahm.akzonobel.nl>
Date: 1998/01/23
Message-ID: <01bd2800$7bcbb260$5310030a@AHM01395.ahm-nl.akzonobel.nl>#1/1

We have two personell tables with a number of equal columns. I have made views on each of these tables.

I have to union these views to make some reports. Therefore I made a new view.
When I use the separate tables in the reports there is no problem. But when I use the view with the union, the performance decreases dramatically.

I can't merge the two tables. But can anyone help me bypassing this problem.
Is there a way to use the two tables in one SQL statement, but not using the UNION operator.

Thanks in Advance.

Hein v. Vroonhoven (Hein.vanVroonhoven_at_AHM.akzonobel.nl) Received on Fri Jan 23 1998 - 00:00:00 CST

Original text of this message

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