Infrastructure for Systems with Large Data Volumes
This section outlines:
-
Salesforce components and capabilities that directly support the performance of systems with large data volumes
-
Situations in which Salesforce uses those components and capabilities
-
Methods of maximizing the benefits you get from the Salesforce infrastructure
-
Lightning Platform Query Optimizer
The Salesforce multitenant architecture uses the underlying database in such a way that the database system’s optimizer can’t effectively optimize search queries. The Lightning Platform query optimizer helps the database’s optimizer produce effective queries by providing efficient data access in Salesforce.
-
Salesforce supports custom indexes to speed up queries. The query optimizer evaluates each index against record-distribution thresholds to decide whether using it makes the query faster.
j