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

Home -> Community -> Usenet -> c.d.o.misc -> Re: performance issue - mass updates

Re: performance issue - mass updates

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 7 Nov 2005 06:48:53 -0800
Message-ID: <1131374933.725206.69110@g44g2000cwa.googlegroups.com>


Where is the explain plan for the update statement?

Why is there a duplicate update that will process the same rows in the example? Error in posting or does this actually happen?

How many indexes exist on the table?

Running one update statement to perform all 40K updates would indeed probably be better.

HTH -- Mark D Powell -- Received on Mon Nov 07 2005 - 08:48:53 CST

Original text of this message

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