有哪些网站是做网批女装,九亭 网站建设,wordpress迁移后后台登陆不,12380网站建设情况看见朋友导入数据#xff0c;花了很长时间都没完成#xff01;其实有很多快速的方法#xff0c;整理下#xff01; 向表中插入数据有很多办法,但是方法不同#xff0c;性能差别很看见朋友导入数据#xff0c;#xff0c;花了很长时间都没完成#xff01;其实有很多快速…看见朋友导入数据花了很长时间都没完成其实有很多快速的方法整理下 向表中插入数据有很多办法,但是方法不同性能差别很看见朋友导入数据花了很长时间都没完成其实有很多快速的方法整理下向表中插入数据有很多办法,但是方法不同性能差别很大.----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 timing on;create table t2asselect sid,sname from t1;已用时间: 00: 00: 25.91select count(*) from t2;----9.数据加载2drop table t2 purge;alter system flush shared_pool;select count(*) from t1;set timing on;create table t2 nologgingasselect sid,sname from t1;已用时间: 00: 00: 04.89select count(*) from t2;----10.数据加载并行drop table t2 purge;alter system flush shared_pool;select count(*) from t1;set timing on;create table t2 nologging parallel 24 --根据自己服务器情况asselect sid,sname from t1;已用时间: 00: 00: 02.89select count(*) from t2; 本条技术文章来源于互联网如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源php中文网
