Create Table ...as select Vs. Insert Statements

[chrisrlong]

Originally posted by gbrabham
It is faster to go with "CREATE TABLE table_name AS SELECT * FROM ..."
This does not generate logging to the database, therefore it is
faster.

Um, no. If you use option 2 and add an APPEND hint, you get the same direct-load benefits

- Chris