Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle partition key update question

Re: Oracle partition key update question

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 5 Jul 2004 06:54:25 +0100
Message-ID: <00a301c46254$8ac75270$7102a8c0@Primary>

The overhead is slightly worse than that. Oracle updates in situ, then deletes and inserts.

It's especially unpleasant if you've prefixed all your local indexes.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated May 1st

Yes, and since at least Oracle 8.1, if you create the table with, or enable 'ROW MOVEMENT' on the record.

Of course, there is an additional overhead to doing this, you are effectively doing a delete and insert, but if you have a packaged application that does silly things you may need to do this.



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Mon Jul 05 2004 - 00:51:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US