Message-Id: <10737.126242@fatcity.com> From: Amar Kumar Padhi Date: Wed, 10 Jan 2001 14:21:18 +0400 Subject: RE: update performance This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C07AEF.121FA4D0 Content-Type: text/plain; charset="iso-8859-1" Use pl/sql, open a cursor and commit data after every 10,000 or more/less records are updated. This will prevent contention of the rollback segments. Thanks, Amar Kumar Padhi Software Cosultant. -----Original Message----- From: Krishna Prasad [mailto:krishna@nehanet.com] Sent: Wednesday, January 10, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: update performance I ahve a requirement to update a table using a joing - details: Table A: (colA, colB,...): 2 million rows Table B: (colA, colC,...): 2 milion rows update cmd: update tableA A set colA = (select B.colC fdrom tableB B where B.tableB.colA = A.tableA.colA ) I tried it in PL/SQL and as the straight SQL but it takes FOREVER without coming back... should I be doiing something better? (I have an index on the two columns on TableB) Thanks -Krishna. ------_=_NextPart_001_01C07AEF.121FA4D0 Content-Type: text/html; charset="iso-8859-1" RE: Date comparison question
Use pl/sql, open a cursor and commit data after every 10,000 or more/less records are updated. This will prevent contention of the rollback segments.
 
Thanks,
Amar Kumar Padhi
Software Cosultant.
-----Original Message-----
From: Krishna Prasad [mailto:krishna@nehanet.com]
Sent: Wednesday, January 10, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
Subject: update performance

I ahve a requirement to update a table using a joing - details:
Table A: (colA, colB,...): 2 million rows
Table B: (colA, colC,...): 2 milion rows
 
update cmd:
 
update tableA A
set colA = (select B.colC fdrom tableB B where B.tableB.colA = A.tableA.colA )
 
I tried it in PL/SQL and as the straight SQL but it takes FOREVER without coming back...
should I be doiing something better?
 
(I have an index on the two columns on TableB)
 
Thanks
-Krishna.