[Leigh]

This is the query I have to update a column in one table, by comparing 2 of its columns to with the columns of another table. The WIE_Physician table has 1655 records, hence the loop, and the temp_fact has just over 1million records. This query takes too long, can someone please help.

Thanks in advance
Leigh

begin
for i in 1..1655 loop

UPDATE temp_fact t SET SUR_ID_WIEPHYSICIAN = i where exists
(select SUR_ID_WIEPHYSICIAN from wie_physician c where c.STRPHYSICIAN_NO = t.STRPHYSICIAN_NO
and c.STRPHYSICIAN_NAME = t.STRPHYSICIAN_NAME and c.SUR_ID_WIEPHYSICIAN = i);

end loop;
end;
/

[amitpatel66]

Your code is incorrect.If the WHERE condition satisfies then all the 1 million records will be updated with current value of "i".

Instead of using EXIST, use the Joins to update that particular record and not all of them