-
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
Insert Record by Email Service Attachments in Salesforce
Email Service Email service is the process that fulfills the business requirement by automated process service by using apex classes to process the content, attachment,…
Protect your Data with Data Classification in Salesforce
Happy Cybersecurity Awareness Month (CSAM)! Did you know that the loss of critical, and often sensitive, information can severely impact the profitability and innovation of your…
What is Enhanced Domain Deployment in Salesforce in 2023?
The next edition of My Domain is enhanced domains. With enhanced domains, all URLs in your organization, including those for your Experience Cloud sites, Salesforce…
Popular Salesforce Videos
Lightning Notifications Library | How and When to Use it in Salesforce? | Toast | Notice
In this video, you will learn about Lightning Notifications Library. We have two types of notifications available in it. 1. Toast 2. Notice In the…
Salesforce Flow to Create Feedback form on Case | How to use Slider, Radio button on Screen Flow
Use Case: In this video, we are creating a screen flow to get feedback from the users when the case is closed. Learnings: 1. How…
What is Billing - Salesforce Revenue Cloud
How can you transform your billing system for subscription and usage models? By dropping your legacy systems and streamlining your processes. In this video, learn…
