-
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.
- [adinserter block='9']
-
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
How to Become a Freelance Salesforce Consultant
Ask any freelancer out there what they love about freelancing. The first thing they tell you is the room to work flexibly, remotely, and how…
Empower Your Business with Goognu’s AWS Consulting Services
In today’s fast-changing digital world, cloud technology has become the backbone of innovation and business growth. Amazon Web Services (AWS) stands out as the most…
Comparison Between Salesforce B2B and B2C Commerce Cloud Solutions
The proliferation of the internet and smart devices has forced us to enter the digital-first economy, where online trade has become the lifeline for most…
Popular Salesforce Videos
What is a Salesforce Admin?
Salesforce administrators are the gatekeepers of their employer's sales and marketing data. They create each user account and determine the proper level of access based…
How To Use Journey Builder In Salesforce Marketing Cloud | Salesforce Tutorial
How to use Journey Builder in Marketing Cloud. This video will cover the following points - 1. Introduction Get a brief introduction to Journey Builder…
Salesforce Winter Release '22 Highlights
Watch this webinar video to learn about new and improved features and how you can take full advantage of the latest enhancements. Let us know…
