Monday, January 9, 2017

What are the fields with Databases index?

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

A) ID
B) Name
C) OwnerID
D) CreatedDate
E) RecordType
F) SystemModstamp
G) Unique Fields
H) External ID fields
I) Master-Detail fields (custom fields are treated as custom indexes for index selectivity conditions and thresholds)
J) Lookup fields (treated as custom indexes for index selectivity conditions and thresholds)

How can we see field is indexed from Salesforce UI?

To see a field is indexed or not, go to fields section of any object and see if index column is checked or not. See the below screenshot for Account object.


No comments:

Post a Comment