优秀个人网站推荐,深圳防疫隔离政策,南通网站建设找哪家好,购物网站如何做看见朋友导入数据#xff0c;花了很长时间都没完成#xff01;其实有很多快速的方法#xff0c;整理下#xff01;向表中插入数据有很多办法,但是方法不同#xff0c;性能差别很大.----1.原始语句drop table t1 purge;create table t1(sid number,sname varchar2(20)) tab…看见朋友导入数据花了很长时间都没完成其实有很多快速的方法整理下向表中插入数据有很多办法,但是方法不同性能差别很大.----1.原始语句drop table t1 purge;create table t1(sid number,sname varchar2(20)) tablespace test;create or replace procedure proc01(sname varchar2)asbeginfor i in 1..10000000loopexecute immediateinsert into t1(sid,sname) values(||i||,||sname||);commit;end loop;end;/alter system flush shared_pool;set timing on;exec proc01(ocpyangtest);已用时间: 02: 02: 54.12----2.绑定变量drop table t1 purge;create table t1(sid number,sname varchar2(20)) tablespace test;create or replace procedure proc02(sname varchar2)asbeginfor i in 1..10000000loopexecute immediateinsert into t1(sid,sname) values(:no||,||sname||) using i;commit;end loop;end;/alter system flush shared_pool;set timing on;exec proc02(ocpyangtest);已用时间: 00: 22: 59.79select count(*) from t1;----3.静态语句drop table t1 purge;create table t1(sid number,sname varchar2(20)) tablespace test;create or replace procedure proc03asbeginfor i in 1..10000000loopinsert into t1 values(i,ocpyangtest);commit;end loop;end;/alter system flush shared_pool;set timing on;exec proc03;已用时间: 00: 20: 42.42select count(*) from t1;----4.批量提交drop table t1 purge;create table t1(sid number,sname varchar2(20)) tablespace test;create or replace procedure proc04asbeginfor i in 1..10000000loopinsert into t1 values(i,ocpyangtest);end loop;commit;end;/alter system flush shared_pool;set timing on;exec proc04;已用时间: 00: 11: 48.42----5.集合drop table t2 purge;create table t2(sid number,sname varchar2(20)) tablespace test;alter system flush shared_pool;select count(*) from t1;set timing on;insert into t2 select sid,sname from t1;已用时间: 00: 01: 02.18commit;select count(*) from t2;----6. 集合appenddrop table t2 purge;create table t2(sid number,sname varchar2(20)) tablespace test;alter system flush shared_pool;select count(*) from t1;set timing on;insert /* append */ into t2 select sid,sname from t1;已用时间: 00: 00: 36.94commit;select count(*) from t2;----7. 集合appendnologgingdrop table t2 purge;create table t2(sid number,sname varchar2(20)) nologging tablespace test;alter system flush shared_pool;select count(*) from t1;set timing on;insert /* append */ into t2 select sid ,sname from t1;已用时间: 00: 00: 35.07commit;select count(*) from t2;----8.数据加载1drop table t2 purge;alter system flush shared_pool;select count(*) from t1;set
