Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> update/select statement tuning help
The table MyTable contains around 3,000,000 + records. I have the following
update statement which takes around 3 hours to execute. Could any body give
me some information on how to speed up the process? Oracle version 8.1.7.
Sort_area_size = 50MB. PK=fldy, index on fldx is also availble.
UPDATE MyTable t
SET (
t.fld1-1, t.fld1-2, t.fld1-3, t.fld1-4, t.fld1-5, t.fld1-6
u.fld2-2, u.fld2-3, u.fld2-4, u.fld2-5, u.fld2-6
thanks and regards,
DGK
Received on Fri Sep 24 2004 - 23:40:24 CDT