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

From: <Christopher.Taylor2_at_parallon.net>
Date: Tue, 9 Apr 2013 10:50:50 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8879BCB3A25_at_NADCWPMSGCMS10.hca.corpad.net>

Nope - the creation date is the original date the index was created.

I really need to come up with a test case but never have time to execute on it.

I'll see if I can get to that today.

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 10:36 AM
To: oracle-l
Subject: Re: Question: MERGE or INSERT /*+ APPEND */ causes INDEX DDL?

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 09 2013 - 17:50:50 CEST

This message: [ Message body ]
Next message: Hans Forbrich: "Re: Web Based SQLPLUS/SQL Developer like tool"
Previous message: Hans Forbrich: "Re: Unwanted SQL Developer inverse connection storming"
In reply to: Peter Hitchman: "Re: Question: MERGE or INSERT /*+ APPEND */ causes INDEX DDL?"
Next in thread: Taral Desai: "Re: Question: MERGE or INSERT /*+ APPEND */ causes INDEX DDL?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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

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