-
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.
-
2 Replies
-
I have been touch with Salesforce support and also created case regarding the same. When trigger gives an error like above and you have tried almost everything to resolve it, that means your trigger exceeding the CPU time limit so the alternative solution could be a batch class processing the records.
-
Above was the one solution that Salesforce support gave initially. After using batch class too, trigger was not able to perform the operations so again contacted with Salesforce support and finally they enabled the custom indexing for some fields(in my case on account fields) which i have to use in my WHERE clause. This made my query run successfully and no more of "Non-selective query" error message come.
Log In to reply.
Popular Salesforce Blogs
The Top Five Nonprofit Agendas and Challenges | Salesforce Nonprofit
While technology and platforms continue to evolve, rules often limit marketers. Meanwhile, the nonprofit industry is addressing hurdles such as rising disasters and community needs,…
Salesforce Artificial Intelligence for Sales Cloud to Increase Productivity and Growth
Salesforce AI for Sales Cloud, as well as additional capabilities like an embedded assistant copilot for Sales, allow every sales professional, leader, and operations team…
Process Builder in Salesforce - Brief Guide
Salesforce's Process Builder is essentially an automated tool for controlling the order of actions or evaluating the requirements for a record. Here are some of…
Popular Salesforce Videos
Salesforce Financial Services Cloud demo
Today's seamlessly connected customer is raising expectations for organizations to "show them they know them" by providing efficient, informed and integrated experiences no matter which…
Salesforce Web-to-Case in under 5 Minutes
we'll see how to make a Salesforce Web-to-Case form quickly and easily, and how to embed it in our Word press website. This whole process…
Gantt Charts in Salesforce Lightning | Salesforce Tutorials
In this video, you will learn to implement the Gantt Chart in your Salesforce org. We will use Google Gantt Chart scripts and we will…
