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

• Original Message ----- From: "David Kurtz" <info_at_go-faster.co.uk> To: <oracle-l_at_freelists.org> 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_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