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. Custom fields which are marked as External ID or Unique.
4. Audit dates (such as SystemModStamp).