Non-selective query against large object type (more than 100000 rows). Consider an indexed filter.

Hello all,

I am getting the error below in my Lead trigger:

Non-selective query against large object type (more than 100000 rows). Consider an indexed filter.

I am guessing my SOQL query in the list is returning too many results. It is:

List<CampaignMember> listCampaignMember = [Select Id,CampaignId,LeadId From CampaignMember Where LeadId IN:setLeadId];

I have read that a solution involves making one of the CampaignMember fields an "External ID" but don't know which one to do this for.

Any ideas on how to optimize my SOQL query or what field I should make an External ID on the CampaignMember object?

Thanks!

May 29, 2013
·
Answer
·
Like
0
·
Follow
0

steve456
Make sure you filter you query for less number of records

or you can call salesforce for indexing a particular field

May 29, 2013
·
Like
0
·
Dislike
0

Starz26
sfdc-admin-sm wrote:
Hello all,

I am getting the error below in my Lead trigger:

Non-selective query against large object type (more than 100000 rows). Consider an indexed filter.

I am guessing my SOQL query in the list is returning too many results. It is:

List<CampaignMember> listCampaignMember = [Select Id,CampaignId,LeadId From CampaignMember Where LeadId IN:setLeadId];

I have read that a solution involves making one of the CampaignMember fields an "External ID" but don't know which one to do this for.

Any ideas on how to optimize my SOQL query or what field I should make an External ID on the CampaignMember object?

Thanks!

try this:

Lead[] l = [Select ID, (Select ID, CampaignID, LeadID From CampaignMembers) From Lead Where ID In :leadIDs];

Then to access the CampaignMember records

For(Lead ld : l){
for(CampaignMember cm : ld.CampaignMembers){
//do work here
}
}