-
Non-selective query against large object type (more than 100000 rows)
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)The above error occurs in production where we have approx 138000 records. We have couple of methods to get this rectified like optimizing the query, null check, making the field external id or unique. Somehow the query Threshold value goes out of the limit that is why the query is not selective. Any help would be appreciated.
-
2 Replies
-
I have been touch with Salesforce support and also created case regarding the same. When trigger gives an error like above and you have tried almost everything to resolve it, that means your trigger exceeding the CPU time limit so the alternative solution could be a batch class processing the records.
-
Above was the one solution that Salesforce support gave initially. After using batch class too, trigger was not able to perform the operations so again contacted with Salesforce support and finally they enabled the custom indexing for some fields(in my case on account fields) which i have to use in my WHERE clause. This made my query run successfully and no more of "Non-selective query" error message come.
Log In to reply.
Popular Salesforce Blogs
A Guide To Writing Your Salesforce Administrator Resume
A Salesforce Administrator ensures companies experience the full potential of Salesforce and its technology. With an average starting annual salary of $79,000 and a 400% growth…
Intriguing Features and Channels on Salesforce+
Earlier this year Salesforce introduced Salesforce+ that includes Live experiences, original series, podcasts, and other content that are all part of Salesforce+. Salesforce+ will illuminate…
What are Global Picklist or Picklist Value Sets in Salesforce
A worldwide Picklist infers a picklist which you'll be able to access for all Salesforce objects. Because it was on the off chance simply making…
Popular Salesforce Videos
Schedule-Triggered Flow to Update Cases at the End of the Day | Schedule a Flow in Salesforce
A schedule-triggered flow starts at the specified time and frequency for a batch of records. Configure the schedule trigger in the Start element of your…
Send Salesforce Field Service Mobile App Device Logs For iOS
This video will demonstrate how to send device logs from the Field Service App for iOS / Android. Salesforce Support may ask you to send…
Governor Limits in Salesforce | Video Tutorial
Watch this amazing video to learn all about Governor Limits in Salesforce and a description of Governor Limits in Salesforce. If you have any doubts…
