Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Views
Have an interesting problem,
select count(*) from table1; 2mins ~1 millon rows
select count(*) from table2; 1min 10 sec ~500,000 rows
view #1 select * from table1 union select * from table2
select count(*) from view#1; 10mins ~1.5 Millons rows
view #2 select * from table1 union all select * from table2
select count(*) from view#2; 7mins ~1.5 Millons rows
Well one may conclude the sga too small etc; both tables inserted into a big one.
select count(*) from tab#1_tab#2; 3mins ~1.5 millon rows
Any one have any thoughts on views (Oracle 7.2.3 HPUX 9.x)
kwhitake_at_moon.jic.com Received on Thu Mar 27 1997 - 00:00:00 CST