SF-Data-Arch Large Data Volume Considerations — All Questions With Answers

Error: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record

SELECT Id, Name FROM Opportunity WHERE CreatedDate > LAST_N_DAYS:365 AND OwnerId = '005XXXXXXXXXXXX'

Error: Too many query rows: 50001

ERROR: List has more than 1 row for assignment to SObject

LIMIT 50000
SELECT Id FROM Custom_Object__c WHERE Status__c = 'Pending'
// Result: Query Exception: Non-selective query against large object

Error: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 1 records: 001D000000ABC12

SELECT Id, Name FROM Account WHERE CreatedDate > 2023-01-01T00:00:00Z AND Custom_External_ID__c = '12345'