Activity Forums Salesforce® Discussions Which fields are automatically Indexed in Salesforce?

  • Nikita

    Member
    August 21, 2019 at 6:01 am

    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

  • Hariom Chaudhary

    Member
    August 21, 2019 at 6:22 am

    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.

Popular Salesforce Blogs

Popular Salesforce Videos