-
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
Mortgage Innovation for Salesforce Financial Services Cloud
Salesforce recently announced a new feature Called Mortgage Innovation for Financial Services Cloud that is designed to streamline the mortgage application process. This new tool includes a guide…
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…
What are Flows In Salesforce in 2023?
A flow is a Salesforce application that collects data and performs actions in your Salesforce org or an external system. To automate a business process…
Popular Salesforce Videos
Getting Information from your Salesforce Account for a Salesforce Connection
Watch this video to learn how to get information from your Salesforce Account for a Salesforce Connection. Do let us know in the comment section…
What are the Objects in Salesforce?
What is the difference between Profile Vs Permission Set? Salesforce Interview Questions and Answers by CRS Info Solutions. Watch this video to learn more. Read…
Learn Apex Triggers Part 2 in Salesforce Development
In this video, we will learn about Apex Triggers in Salesforce development: We'll will be discussing the following things in this video: 1. What are…
