> SQL:
> update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where mobile_num in (select
> mobile_num from LOADED_MOBILE_NUMBERS)
Could you try using UPDATE ... FROM (SELECT ....) AS .. style syntax?
About 20 minutes ago, I changed a 8 minute update to an most instant by
doing that.
regards
Iain