直接insert与存储过程insert性能区别

16:40:43 SQL> insert into t_direct_table select level from dual connect by level<=1e6;
 
1000000 rows inserted
 
Executed in 1.108 seconds
 
16:41:11 SQL> insert into t_direct_table select * from t_direct_table;
 
1000000 rows inserted
 
Executed in 0.562 seconds
 
16:41:26 SQL> create or replace procedure proc_t_direct_table
           2  as
           3  begin
           4  insert into t_direct_table select level from dual connect by level<=1e6;
           5  insert into t_direct_table select * from t_direct_table;
           6  commit;
           7  end;
           8  /
 
Procedure created
 
Executed in 1.372 seconds
 
16:44:17 SQL> truncate table t_direct_table;
 
Table truncated
 
Executed in 7.722 seconds
 
16:45:37 SQL> exec proc_t_direct_table;
 
PL/SQL procedure successfully completed
 
Executed in 1.716 seconds

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

转载于:http://blog.itpub.net/9240380/viewspace-750860/