-
How to resolve error “Non-selective query against large object type” in Salesforce?
When you get the error “Non-selective query against large object type”? How to resolve it in Salesforce?
-
2 Replies
-
Whenever an object has greater than 100K records any query on that object must be “selective”. For a query to be selective it must have enough indexed filters (where clauses) so that less than 10% of the records (in our example 10K) are returned before applying the limit statement.
- [adinserter block='9']
-
If you're running a trigger on objects that have more than 200,000 records, it's possible that you'll receive the error, "System.QueryException: Non-selective query against large object type." We'll go over the a few possible fixes. Resolution.
Options to resolve error.
Log In to reply.
Popular Salesforce Blogs
Overcome Integration Mistakes With Salesforce Partners
In the age of API (application programming interface) and iPaaS (integration platform as a Service), enterprise data can easily be unified. Organizations are using the…
Interactive Quotes in Salesforce: What They Are and the Benefits for Your Business
As selling becomes more complex, reps need more time to connect with customers. Research shows that only 28% of sales reps spend their week selling. The…
Introduction to Custom Label in Salesforce
Salesforce is a strong platform that lets you modify the functionality and user interface to meet your company's demands. Salesforce provides the option to generate…
Popular Salesforce Videos
Process Builder In Salesforce | Tutorial Video
Do you want to create a record for any object from a workflow? Do you want to call your Apex class from a workflow? Do…
Salesforce Macros - All You Need To Know!
Macros in Salesforce allows you to perform repetitive actions in Service Cloud for the records of Account, Contact, Case, and Lead (Supported for Feed based…
What is Salesforce Marketing Cloud?
Salesforce Marketing Cloud helps in digital marketing automation and analytics. In this video, we have provided detailed information about what is salesforce cloud and its…
