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

From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Tue, 9 Apr 2013 16:36:13 +0100
Message-ID: <CAPMSPxP+p9jc9aWFrdrK-1a4VBgi9xO5qkOcfwb6m25RexJTvQ_at_mail.gmail.com>

Hi
I have never taken that to mean it does a DDL operation, but I'll admit I have never actually traced this type of operation. Surely for it to be DDL it means that the index is dropped and re-created? Regards
Pete

On 9 April 2013 15:08, <Christopher.Taylor2_at_parallon.net> wrote:

> Nope - all the partitions are pre-created.
>
> 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
>
>

-- 
Regards

Pete


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

Received on Tue Apr 09 2013 - 17:36:13 CEST