-
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.
-
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
6 Ways to Make the Most Out of WordPress Salesforce Integration
Salesforce is among the robust CRMs available in the market. It offers many tools for storing and organizing your company’s data as well as your…
Real Time Access To External Data Using Salesforce Lightning Connect
Salesforce as we all know is the most renowned CRM-in-the-cloud of this era. In addition to endless top features, another vital aspect is its ability…
How to use Amazon AppFlow to transfer data between Salesforce and AWS
Managing the flow of data between AWS and Software-as-a-Service SaaS applications like Salesforce can be difficult, time-consuming, and expensive. Developers can often spend months writing…
Popular Salesforce Videos
Security in Salesforce | Learn About the Security Levels in Salesforce
This "???????? ?? ??????????" video by Edureka will help you understand the different levels of security in Salesforce. It will also talk about some of…
The World of Salesforce Einstein
Salesforce Einstein is artificial intelligence (AI) technology that has been developed for the Salesforce Customer Success Platform. ... Upgrades include Einstein Vision, which brings image…
Salesforce Consumer Goods Cloud Demo
Salesforce Consumer Goods Cloud is an intelligent, seamless B2B CRM solution specifically designed for the consumer goods industry. Watch this video to learn more.
