Using an oracle DB, 11g r2, I need to write a pl/sql which updates one column in table A where the PK exists in table B, with commits ever ~50,00 rows.
3200000 rows are involved in the update, and table A has ~70 million rows total.
What is the most efficient way to do this?
Table A (has ~70 million rows, and ~100 columns. Only one needs to be updated):
CREATE TABLE ORD ( ORDER_KEY NUMBER NOT NULL, /* ~95 other columns */ ORDER_TYPE" NUMBER(10,0) /* col needing update */ )
Order key has an index.
Table B (contains the id's of the rows from table a which need the update):
CREATE TABLE GR_ORD (ORDER_KEY NUMBER NOT NULL)