SQL> select count(*) from aaa_partitioned_table;

COUNT(*)
----------
1000000

Executed in 0.375 seconds

SQL> truncate table aaa_partitioned;

Table truncated

Executed in 2.172 seconds

SQL> insert /*+ APPEND */ into aaa_partitioned nologging select * from aaa_partitioned_table;

1000000 rows inserted

Executed in 29 seconds

SQL> commit;

Commit complete

Executed in 0 seconds[@more@]

加快insert into select速度with hints and nologging

相關文章