Home » RDBMS Server » Performance Tuning » Bulk Update (Oracle 11g)
Bulk Update [message #494586] Tue, 15 February 2011 18:44 Go to next message
rcd70
Messages: 14
Registered: April 2006
Location: Auckland, New Zealand
Junior Member
Hi

I am trying to update a million rows in one table with the values from another tables.
Table being updated CI_ADJ_CHAR column CHAR_VAL_FK1
Table from which values will be used CK_ADJ columns (cx_id, ci_id)

The CI_ADJ_CHAR.CHAR_VAL_FK1 values match CK_ADJ.CX_ID and should be updated with the value CK_ADJ.CI_ID.

The CK_ADJ table has 1.3 million rows and both the columns have indexes defined. Table definitiuon mentioned below


The CI_ADJ_CHAR table has 14 million rows and will update 1 million rows and has an index on the ADJ_ID column but not on the CHAR_VAL_FK1 column.

Please advise.
Re: Bulk Update [message #494587 is a reply to message #494586] Tue, 15 February 2011 18:54 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to post DDL for both tables.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

>Table from which values will be used CK_ADJ columns (cx_id, ci_id)
EXACTLY how you intend to "use" two columns (cx_id, ci_id) to go into a single column CHAR_VAL_FK1?
if CHAR_VAL_FK1 really is a FK, what happens when no PK exists?
Previous Topic: Optimal REDO log file size
Next Topic: Performance issue in jsp application
Goto Forum:
  


Current Time: Thu Mar 28 19:13:47 CDT 2024