What are the fields with Database Index?

Fields with Database Index?

Below are the standard and custom fields with database index in Salesforce.

– ID
– Name
– wnerID
– CreatedDate
– SystemModstamp
– RecordType
– Master-detail fields (custom fields are treated as custom indexes for index selectivity conditions and thresholds)
– Lookup fields (treated as custom indexes for index selectivity conditions and thresholds)
– Unique fields
– External ID fields

How can we see filed is indexed from Salesforce UI?

To see a field is indexed or not, go to fields section of an object and see indexed column is checked or not. See the below image for reference. Fields highlighted with yellow color are indexed fields.

Index

 

Leave a Reply