Performance Measurement /append & parallel


SQL> create table sr_test1 as select * from us_gdhst where rownum>1;
Table created.
Elapsed: 00:00:01.06
SQL> create table sr_test2 as select * from us_gdhst where rownum>1;
Table created.
Elapsed: 00:00:01.07
SQL> create table sr_test3 as select * from us_gdhst where rownum>1;
Table created.
Elapsed: 00:00:01.07
SQL> create table sr_test4 as select * from us_gdhst where rownum>1;
Table created.
Elapsed: 00:00:01.07
SQL> insert into sr_test1 select * from us_gdhst;
900961 rows created.
Elapsed: 00:01:29.08
SQL> truncate table sr_test1;
Table truncated.
Elapsed: 00:00:13.04
SQL> insert /*+ append */ into sr_test2 select * from us_gdhst;
900961 rows created.
Elapsed: 00:01:28.02
SQL> truncate table sr_test2;
Table truncated.
Elapsed: 00:00:00.02
SQL> insert /*+ parallel (sr_test3,2) */ into sr_test3 select * from us_gdhst;
900961 rows created.
Elapsed: 00:01:30.04
SQL> truncate table sr_test3;
Table truncated.
Elapsed: 00:00:11.07
SQL> insert /*+ append parallel 2 */ into sr_test4 select * from us_gdhst;
900961 rows created.
Elapsed: 00:01:30.08
SQL> truncate table sr_test4;
Table truncated.
Elapsed: 00:00:00.02

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: