Re: INSERT versus CTAS

  • From: Alexander Gorbachev <gorbyx@xxxxxxxxx>
  • To: jaromir@xxxxxxxxxxxx
  • Date: Sun, 12 Dec 2004 20:20:53 +0100

Right, tables have no indexes - they are created later.

Btw, is APPEND and PARALLEL hints for DML on tables with indexes working at all?

On Sat, 11 Dec 2004 23:35:42 +0100, jaromir nemec <jaromir@xxxxxxxxxxxx> wrote:
> > 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
--
//www.freelists.org/webpage/oracle-l

Other related posts: