You need to sign in to do that
Don't have an account?
ISBF
Users are unable to edit records
Hi,
My users are unable to edit any record. They are getting error:
Error:Apex trigger trgLead caused an unexpected exception, contact your administrator: trgLead: execution of BeforeUpdate caused by: System.QueryException: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing. Even if a field is indexed a filter might still not be selective when: 1. The filter value includes null (for instance binding with a list that contains null) 2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times): Trigger.trgLead: line 25, column 1
My users are unable to edit any record. They are getting error:
Error:Apex trigger trgLead caused an unexpected exception, contact your administrator: trgLead: execution of BeforeUpdate caused by: System.QueryException: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing. Even if a field is indexed a filter might still not be selective when: 1. The filter value includes null (for instance binding with a list that contains null) 2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times): Trigger.trgLead: line 25, column 1
Locate the object that is over 100000 records, find that query, and figure out how to use indexed fields for your use case. If it's a custom field you are filtering on, then consider setting that field to also be an "External ID" which salesforce will index.
This is a multi-tenant performance governor limit here, salesforce does not want poor performing queries to hog resources when they should be indexed queries anyway.
Links:
https://developer.salesforce.com/blogs/engineering/2015/06/know-thy-salesforce-field-indexes-fast-reports-list-views-soql.html
Related answers:
https://developer.salesforce.com/forums/?id=906F0000000AvA1IAK