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: A question about update and insert/delete

Re: A question about update and insert/delete

From: <Mark.Powell_at_eds.com>
Date: 4 Feb 2005 09:12:46 -0800
Message-ID: <1107537166.967382.300920@l41g2000cwc.googlegroups.com>


In brief an update generates undo and changes to undo results in redo as does the update. The more data I change the more undo and redo generated. Then there are the indexes.

Even if Oracle was designed to only update what changed for the full row update it has to check every column compared to one for the single column update. For a 20 column row that is 19 additional compare operations.

I believe that Oracle only makes this test for indexed columns so that if you update an indexed column to itself no change is in fact made to the index but a full row update is forcing Oracle to do extra work that a single column update may not include.

HTH -- Mark D Powell -- Received on Fri Feb 04 2005 - 11:12:46 CST

Original text of this message

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