The following fields are automatically indexed in Salesforce:
Custom fields marked as an external ID or a unique field
Primary keys (ID, Name, and Owner fields)
Audit dates (such as SystemModStamp)
Foreign keys (Lookup or Master–Detail relationship fields)