-
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
Top 8 Salesforce Service Cloud Einstein Features
The Salesforce CRM platform, the world leader in customer relationship management, doesn’t stop at optimizing its performance. In this way, it extends the functionalities of…
Maximizing Business Potential with Salesforce Managed Services
Introduction In today's competitive business landscape, organizations need robust tools and platforms to streamline their operations, improve customer engagement, and drive growth. Salesforce, as a…
Which Industries Can Use Salesforce in 2024?
What is Salesforce? Salesforce is a cloud-based CRM software. It has a ton of features to help companies with their customer relationships, lead management, case…
Popular Salesforce Videos
Tips to Crack the Salesforce Administrator Certification Exam in One Go
Do you want to become Salesforce administrator certified? So in this video Shrey has shared the important topics to crack the Salesforce Administrator Exam. Following…
Salesforce: How To Set Up Einstein Bot
With Einstein Bots, you can keep your service reps free from simple, repetitive tasks and they can spend more time on complex customer cases. If…
Salesforce Steps Into Crypto With New NFT Cloud
Salesforce keeps surprising us with its new updates and features. It’s official – Salesforce has launched its NFT Cloud pilot. Click the link to know…
