What field type can be used in the WHERE clause to improve SOQL query performance in Salesforce?

The following fields are indexed by default:

1. Primary keys (Id, Name and Owner fields).
2. Foreign keys (Lookup or Master-Detail relationship fields).
3. Audit dates (such as SystemModStamp).
4. Custom fields marked as External ID or Unique.