-
Non-selective query against large object type (more than 100000 rows)
Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing.
Even if a field is indexed a filter might still not be selective when:
1. The filter value includes null (for instance binding with a list that contains null)
2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times)The above error occurs in production where we have approx 138000 records. We have couple of methods to get this rectified like optimizing the query, null check, making the field external id or unique. Somehow the query Threshold value goes out of the limit that is why the query is not selective. Any help would be appreciated.
Log In to reply.
Popular Salesforce Blogs
Salesforce Commerce Cloud - The Gateway to B2B eCommerce Success
The B2B eCommerce industry is constantly changing. These changes are more profound and permanent than any that occurred in the past, given the recent developments…
Salesforce Financial Services Cloud Spring '23 Highlights
Shake off those winter blues with the new features coming in Salesforce's Spring '23 for Financial Services Cloud. Whether it's ARC enhancements, interaction summary automation,…
Learn All About Standard Controllers in Salesforce | The Developer Guide
The Visualforce controller is used to access visual markers associated with a specific link or button. These controllers can be used to provide access to…
Popular Salesforce Videos
How Salesforce Industries can be Used on Top of Salesforce?
Salesforce Industries offers pre-built solutions on the Salesforce platform that solve the needs of particular industries. Vlocity takes these common requirements and packages them into…
Salesforce Stock CRM Huge News!
Why is Salesforce Stock CRM Stock going UP? Is Salesforce stock a buy? Should I buy CRM Stock? Is Salesforce stock a good investment? In…
MuleSoft Integration: GoToWebinar to Salesforce - Learn Salesforce Series
In this video, you will learn how to use MuleSoft integration platform to transfer attendees data from GoToWebinar to Salesforce- 1. Set up GoToWebinar account,…