Indexes, being selective, and query optimization
In this section, we will review when system and custom indexes maintained by the Salesforce Platform are used to make queries more performant and once larger query results are returned, the ways in which they can be most effectively consumed by your Apex logic.
Standard and custom indexes
As with other databases, the Salesforce Platform maintains database indexes as record data is manipulated to ensure that, when data is queried, such indexes can be used to improve query performance. Due to the Salesforce Platform’s multitenancy, it has its own database index implementation that considers the needs of each tenant.
By default, it maintains standard indexes for the following fields:
IDNameOwnerIdCreateDateCreatedByIdLastModifiedDateLastModifiedByIdSystemModStampRecordType- Any Master-Detail fields
- Any Lookup fields
- Any fields marked...
