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_WIEPHYSI CIAN = i where...