Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Very bad performances on Oracle
Why don't you do a basic update without any loop ?
You will see a lot of improvments! ;-))
update MyTable
set PostCodeVar = TO_CHAR ( PostCode ), PostCode = null
that's all. It should be much much faster. Patrick Received on Fri Feb 12 1999 - 11:31:10 CST