I am a user who has access to 10k records in an org but my SOQL returns 200k records. What is the expected error and any workaround available to resolve this error.

I have 2 custom object, parent__c and child__c. I have a status__c field in child__c which is a picklist field with value a,b,c,d,e. The picklist values have priority like a>b>c>d>e. Need to write a trigger to update parent__c status with highest priority status from child__c.

I have 2 custom object, parent__c and child__c. I have a status__c field in child__c which is a picklist field with value a,b,c,d,e. The picklist values have priority like a>b>c>d>e. Need to write a trigger to update parent__c status with highest priority status from child__c.