In this section, we will review when system and custom indexes maintained by the Lightning 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.
Indexes, being selective, and query optimization
Standard and custom indexes
As with other databases, Lightning 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 Lightning Platform's multitenancy, it has its own database index implementation (instead of using the underlying Oracle database indexes) that considers the needs of each tenant...
