-
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
Why Salesforce Data Cloud is No Longer Optional for Modern Salesforce Teams
Businesses generate customer data from multiple touchpoints, including CRM systems, websites, marketing platforms, ERP applications, support channels, and third-party tools. When this information remains scattered…
Salesforce Lightning Scheduler Mastery In 2025
Salesforce Lightning Scheduler is a powerful tool that can revolutionize how your team schedules appointments and manages resources. In 2025, mastering this tool is crucial…
Salesforce Engage | Propel Customer Engagement with Relevancy
Marketing without customer engagement is nothing more than an on-air commercial that nobody wants to see. Every day the competition is intensifying, and keeping customers…
Popular Salesforce Videos
How Can Salesforce Help To Transform Business Into A Sales Powerhouse?
This video will help you understand what is Salesforce and how it can help transform businesses. Salesforce CRM will help to transform your organization to…
How to Start Your Career in Salesforce?
Are you still confused about "How to start your career in Salesforce?" Get your answer now! We hope you enjoy the video and it helps…
External File Storage for Salesforce | Learning Guide
We demonstrate how to avoid Salesforce's file storage limit by using external files. Read the article and download the sample file. https://dbservices.com/blog/external-file-storage-for-salesforce
