RE: Question: MERGE or INSERT /*+ APPEND */ causes INDEX DDL?

According to this, it implies that index ddl does occur for direct-load operations:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm

"Oracle Database performs index maintenance at the end of direct-path INSERT operations on tables (partitioned or non-partitioned) that have indexes. This index maintenance is performed by the parallel execution servers for parallel direct-path INSERT or by the single process for serial direct-path INSERT. You can avoid the performance impact of index maintenance by dropping the index before the INSERT operation and then rebuilding it afterward."

Am I misreading that?

Chris

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Peter Hitchman Sent: Tuesday, April 09, 2013 9:01 AM
To: oracle-l
Subject: Re: Question: MERGE or INSERT /*+ APPEND */ causes INDEX DDL?

Hi
Another idea. Are you using deferred segment creation? So that when a value comes in that is the first for a given partition the segment gets created and is recorded as DDL? Regards
Pete

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