What field type can be used in the WHERE clause to improve SOQL query performance in Salesforce?

What field type can be used in the WHERE clause to improve SOQL query performance in Salesforce?

The following fields are indexed by default:

1. Primary keys (Id, Name and Owner fields).
2. Foreign keys (Lookup or Master-Detail relationship fields).
3. Audit dates (such as SystemModStamp).
4. Custom fields marked as External ID or Unique.

Cheers!!!

Leave a Reply