Re: INSERT versus CTAS

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Sat, 11 Dec 2004 23:35:42 +0100
Message-ID: <029101c4dfd1$c15c5830$3c02a8c0@JARAWIN>

> I assume that CTAS would be more performant for IOT

Right, on the other side for (heap) tables or partitioned tables there is a great difference in performance between CTAS over INSERT APPEND but only in case when the target table has indexes (but INSERT APPEND to a table with indexes is better than INSERT without APPEND)

>From your description I assume that your target tables have no indexes. In
this case I didn't observed significant difference in behavior between CTAS (nologging parallel) and INSERT APPEND (with parallel dml enabled) on tables and range partitioned tables.

HTH Jaromir D.B. Nemec

http://www.db-nemec.com

Original Message ----- From: "Alexander Gorbachev" <gorbyx_at_gmail.com> To: "ORACLE-L" <oracle-l_at_freelists.org> Sent: Saturday, December 11, 2004 4:41 PM Subject: INSERT versus CTAS

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Dec 11 2004 - 16:40:56 CST