insert all 操作 减少扫描次数

create table tx1 (id1 int ,id2 int);
create table tx2 (id1 int, id2 int);
create table tx3 (id1 int, id2 int);

create table tx (id1 int, id2 int);
insert into tx values(1,1);
insert into tx values(2,2);
insert into tx values(3,3);

insert all
when id1=1
  then into tx1
when id1=2
  then into tx2
when id1=3
  then into tx3
select * from tx;
select  *  from tx1 a;
select  *  from tx2 a;
select  *  from tx3 a;
drop table tx1 purge;
drop table tx2 purge;
drop table tx3 purge;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11813230/viewspace-690235/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11813230/viewspace-690235/