Sunday, July 12, 2015

Using Append Hint to speed up insert operations


SQL> INSERT INTO farhat.USER_LOG1 SELECT * FROM MOHE.USER_LOG WHERE ROWNUM <=2000000 ; 
1999999 rows created.

Elapsed: 00:02:42.56
SQL> COMMIT;

Commit complete.

Elapsed: 00:00:00.00
SQL> TRUNCATE TABLE FARHAT.USER_LOG1;

Table truncated.

Elapsed: 00:00:00.53
SQL> INSERT /*+ APPEND */ INTO FARHAT.USER_LOG1 SELECT * FROM MOHE.USER_LOG WHERE ROWNUM <= 2000000;

2000000 rows created.

Elapsed: 00:00:58.11
SQL>

No comments:

Post a Comment