Book Image Enterprise Architecture

By : Andrew Fawcett
Book Image Enterprise Architecture

By: Andrew Fawcett

Overview of this book

Table of Contents (20 chapters) Enterprise Architecture
About the Author
About the Reviewers

Indexes, being selective, and query optimization

In this section, we will review when system and custom indexes maintained by the 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, 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 design of the multitenant platform, it has its own database index implementation (instead of using the underlying Oracle database indexes) that considers the needs of each tenant. By default, it maintains standard indexes for the following fields:

  • ID

  • Name

  • OwnerId

  • CreateDate

  • CreatedById

  • LastModifiedDate

  • LastModifiedById

  • SystemModStamp

  • RecordType

  • Any Master Detail fields

  • Any Lookup fields

  • Any fields marked as Unique

  • Any fields marked as External Id

Once your application...