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