Re: Oracle partition key update question
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 5 Jul 2004 06:54:25 +0100
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
----- Original Message -----
From: "David Kurtz" <info@xxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Sunday, July 04, 2004 11:37 PM
Subject: RE: Oracle partition key update question
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
