-
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
From Nice-to-have to Necessity : The Role of Personalization in Banking | Salesforce
Over 79% of U.S. consumers perceive their relationship with banks as purely transactional. And banks across the country are striving to change that equation. Technology…
Building Apps Using Salesforce AppExchange
Introduction Salesforce AppExchange was launched in 2005. Salesforce AppExchange is an Online Store just like the 'Play store' in Android phones. It is the marketplace…
What are the Basics of Async Apex Methods in 2024?
Hello Ninjas, Let's talk about Async Apex Method. Before that let's see some basics of async process. Many of the time while coding we want…
Popular Salesforce Videos
Introduction to Set & Map in Salesforce || What is Set || What is Map ||
From Salesforce instructor, Become a Salesforce Expert. A brief introduction about what is a Set, map, and what are their importance? Check out the video to…
Salesforce Admin Certification 2020 Questions Explained with References - Part I
How to prepare and pass Salesforce Admin Certification with Practice Exam Questions 2020 practice questions and answers for the Salesforce Administration Salesforce Certified Admin Exam…
How UiPath Robots Upload Files to Salesforce
How #UiPath Robots upload files to #Salesforce and assign to #Case without custom activity just RAW REST API. 0:00 Preview0:55 Intro1:20 Logic in one picture1:38…
