SQL & PL/SQL

Hello,

This may be a silly question.

I am trying to update ID column of table by taking max(id) from ctrl table.

UPDATE 105_HCA_ACT

SET ID = (select max(ID) from CTRL where E_ID = '105');

This is running for about 10 mins as the no. of records in 105_HCA_ACT are about 1 million.

Is there a better way to do it. Also, I do not have any common columns in these tables.

Thanks in advance