Attempted to set a value to a field of the account object across 70000 records using anonymous apex execution causes below exception;
System.LimitException: Apex CPU time limit exceeded
This is the code I tried,
List<Account> accts = [SELECT Id, EMP_number__c, SOCIAL_Number__c FROM Account WHERE EMP_number__c != null ];
for (Account a : accts) {
a.SOCIAL_Number__c = a.EMP_number__c;
}
update accts;
How could I set this EMP_number__c TO SOCIAL_Number__c through-out 70000 records?