CATS VS Insert into select

Test results:

Insert Append Test Cases
Test Case	SQL	Exec in Secs
no append	insert into test select * from test_source;	201
append	insert /*+ append  */ into test select * from test_source;	95

 

CTAS Test Cases
Test Case	SQL	Exec in Secs
CTAS, no parallel	create table test as select * from test_source;	97
CTAS Parallel	alter session force parallel ddl parallel 3;   alter session force parallel query parallel 3;  create table test as select * from test_source;	50

Insert /*+ append */into

https://oracle-base.com/articles/misc/append-hint

other reference:

https://asktom.oracle.com/pls/apex/asktom.search?tag=ctas-and-insert-into