Re: Does primary key structure impact UPDATE performance?
- From: Jared Still <jkstill@xxxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 16 May 2004 22:22:20 -0700
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@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:
