各种insert插入速度比较

SQL> select count(*) from t;

COUNT(*)
----------
5442048
***********************************
SQL> alter table t1 nologging;
SQL> insert /*+append*/ into t1
2 select * from t;

5442048 rows created.

Elapsed: 00:00:55.73
****************************
SQL> create table t1 nologging parallel (degree 2) as select * from t;

Table created.

Elapsed: 00:00:56.79

********************************
SQL> insert /*+APPEND */ into t1
2 select /*+ parallel(t,4) */ * from t;

5442048 rows created.

Elapsed: 00:01:38.39

***********************************
alter table t1 nologging;
SQL> insert into t1
2 select * from t;

5442048 rows created.

Elapsed: 00:01:46.18
***********************************

SQL> alter table t1 logging;

Table altered.
SQL> insert into t1
2 select * from t;

5442048 rows created.

Elapsed: 00:02:03.51

*********************************
SQL> create table t1
2 as
3 select * from t;

Table created.

Elapsed: 00:03:03.34

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

转载于:http://blog.itpub.net/9599/viewspace-472936/