Re: Does primary key structure impact UPDATE performance?

From: Jared Still <jkstill_at_cybcon.com>
Date: Sun, 16 May 2004 22:22:20 -0700
Message-Id: <1084771340.17431.1982.camel@poirot>

On Sun, 2004-05-16 at 19:07, Thomas Jeff wrote:
> >From the 10046 traces, the performance of the update on the first table
> is clearly far better then on the 2nd table. Just one update on the
> 2nd table is taking an average of 2 seconds to complete.

Is that one row that is taking 2 seconds?

If not, how many blocks are affected?
(indexes and table)

Jared

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 May 17 2004 - 00:13:11 CDT