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: <ak_tiredofspam_at_yahoo.com>
Date: 4 Feb 2005 07:36:35 -0800
Message-ID: <1107531395.253413.48010@o13g2000cwo.googlegroups.com>


>> We have found out that a single update with a single WHERE clause
(the table is indexed according to the Column given in where clause), takes more time compared to a DELETE + INSERT statement. ... <<

if you have a table
create table a(pk number not null primary key, cv varchar2(100));

that is originally populated with narrow rows, PKs only

insert into a values(1, null);
insert into a values(2, null);
....
insert into a values(1000, null);

anf then you start inflating each and every row: update a set cv='very very very long string';

such an update could take much longer than delete+insert, that's normal. Received on Fri Feb 04 2005 - 09:36:35 CST

Original text of this message

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