-
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
The Benefits of Outsourcing Salesforce Support Services
Outsourcing Salesforce support services can offer numerous advantages for businesses looking to optimize their Salesforce investment without the burden of managing an in-house team. By…
Automation Hero | Salesforce Process Builder a step ahead Workflow
Every day at our workplace, we spend a considerable amount of time doing routine work processes that mostly repetitive and do not require any special…
Salesforce – Women in Tech!
Women in Tech in Salesforce Ecosystem The days of gender inequality in this Tech World are long gone. The Salesforce WIT ecosystem is one such initiative…
Popular Salesforce Videos
Salesforce Visualforce and Force.com Development Tutorial || Beginner
Learn to set up a web page using force.com and create forms for users to input information into Salesforce. For more Salesforce tips and tricks…
Salesforce Data Loader | Import Relational Data
What is Data Loader and How to use it to import or export data to or from Salesforce? 00:00 What is Data Loader 01:00 How…
Salesforce Checkout: Manage Your Subscription & Buy Licenses
Watch this video to understand how to manage your Salesforce subscription and buy licenses on your own. This makes an easy process even easier, this…