-
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
Learn All About Salesforce Sales Cloud Summer'21 Top Features
Salesforce is the world’s number one Sales CRM. Sales Cloud allows sales teams anywhere in the world to streamline administrative processes, improve lead management and…
How to Configure Salesforce in Outlook | The Developer Guide
Salesforce for Outlook is an application we will introduce to our Outlook email customer to assist with keeping the information in a state of harmony…
LWC Interview Question – Part 2
Certainly! Here's a mix of Lightning Web Component (LWC) interview questions suitable for both freshers and experienced developers: What are the different types of data…
Popular Salesforce Videos
Salesforce Apex Class | Salesforce Development | SFDC Development
This video covers how to create an Apex Class in Salesforce and Execute the Apex Class. Do let us know in the comment section if…
Salesforce Career Personality Quiz
Which Salesforce career path is right for you? Take this 23 question quiz to learn which Salesforce career is the best match for your personality…
Learn About How to Set Profiles in Salesforce?
Learn about Profiles in Salesforce and types of profiles, Standard and Custom Profiles. Watch this video and do let us know in the comment section…
