Hi all, I'm having a performance problem with a view based on the union of two tables: create table t1(c1 varchar(10), recno number); alter table t1 add primary key (recno); insert into t1old values ('r1', 1); insert into t1old values ('r2', 2); create table t1old(c1 varchar(10), recno number); alter table t1old add primary key (recno);