You need to sign in to do that
Don't have an account?
Ad.bayles
Is the Email field on Lead indexed ?
My Org has more than 100k leads and I need to make a SOQL query on the Lead Object.
My question is, if query on the standard email field, will I hit the governor limit ?
My query would look like :
for(Lead lid : [SELECT email,OwnerId FROM Lead WHERE email != null AND email =:setLeadEmail AND IsDeleted = false AND IsConverted = false ]
It seems the email field for lead is indexed. Check the standard indexed fields below (Source)
The standard Salesforce indexed fields are: