Fields with Database Index?
Below are the standard and custom fields with database index in Salesforce.
– 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.