-
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
Efficient Salesforce Documentation with Data Dictionaries in 2024
In the dynamic world of Salesforce, the management and understanding of metadata plays a crucial role in maintaining robust business processes. For teams working within…
Why Should You Choose Salesforce Revenue Cloud & CPQ!
Streamline Your Lead to Cash Business Processes in a Single Unified Platform Salesforce Revenue Cloud Suite is part of the Salesforce Customer 360 platform. It is…
The Complete Guide to Controllers in Salesforce
Salesforce controllers connect with the database and pull the information from the database to see the information through a page made by the summit page.…
Popular Salesforce Videos
Tips on Lightning Combo Box, Events in Lightning App Builder, and More
Watch this video by Salesforce Developers to get the tips on Lightning Combo Box, Events in Lightning App Builder, and more. Watch and learn, do…
Google Home Assistant Integration with Salesforce
Check out the below link for pdf view. https://www.linkedin.com/pulse/google-home-assistant-integration-salesforce-rajkiran-dewara/
Salesforce Grid Component Modernization with Webix Widgets
Take a break and watch a short video about how we modernized the Salesforce Grid component with Webix.
