Activity › Forums › Salesforce® Discussions › Which fields are automatically Indexed in Salesforce?
Tagged: Custom Fields, External ID, Foreign Keys, Indexed Fields, Primary Keys, Record Type Id, Salesforce Record, Salesforce Record ID
-
Which fields are automatically Indexed in Salesforce?
Posted by Achintya on August 21, 2019 at 5:55 AMWhich fields are automatically Indexed in Salesforce?
Hariom Chaudhary replied 6 years, 8 months ago 3 Members · 2 Replies -
2 Replies
-
Hi Achintya,
Fields that are automatically indexed in Salesforce are:
- RecordTypeId
- Division
- CreatedDate
- Systemmodstamp (LastModifiedDate)
- Name
- Email (for contacts and leads)
- Foreign key relationships (lookups and master-detail)
- The unique Salesforce record ID, which is the primary key for each object.
Salesforce also supports custom indexes on custom fields, with the exception of multi-select picklists, text area (long), text area (rich), non-deterministic formula fields, and encrypted text field
- [adinserter block='9']
-
Hi,
Only the following fields are automatically indexed in Salesforce:
Primary keys (Id, Name and Owner fields).
Foreign keys (lookup or master-detail relationship fields).
Audit dates (such as SystemModStamp).
Custom fields marked as an External ID or a unique field.
Log In to reply.