Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Problem with union in Oracle 7.3
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