function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ad.baylesAd.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 ]
Best Answer chosen by Ad.bayles
neophyteneophyte


It seems the email field for lead is indexed. Check the standard indexed fields below (Source)

 

The standard Salesforce indexed fields are:

  •  Lead: Company, Email, Lead Owner, Name.
  • Contact: Account Name, Contact Owner, Email, Name, Reports To.
  •  Account: Account Name, Account Owner, Account Record Type, Parent Account,
  •  On top of these, system time fields (last modified, created date etc) and any lookup fields are also indexed.