---
schema_version: "1"
id: 6088c9b222e2c7b14d4476430c22a534d36e1ef45d8ce81fd6978a0f31a935d2
title: Infrastructure for Systems with Large Data Volumes
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/salesforce-large-data-volumes-bp/guides/cce/ldv-deployments/ldv-deployments-infrastructure-for-performance.md
canonical_url: https://developer.salesforce.com/docs/platform/salesforce-large-data-volumes-bp/guide/ldv-deployments-infrastructure-for-performance.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: ccd5b929b34a09002a33ae67835c9331b7a3d54123ac6873df037544ab341748
products:
  - Best Practices for Deployments with Large Data Volumes
  - Platform Developer Content
---

# 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](https://developer.salesforce.com/docs/platform/salesforce-large-data-volumes-bp/guide/ldv-deployments-infrastructure-salesforce-query-optimizer.md)**  


    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.

-   **[Database Statistics](https://developer.salesforce.com/docs/platform/salesforce-large-data-volumes-bp/guide/ldv-deployments-infrastructure-database-statistics.md)**  

-   **[Skinny Tables](https://developer.salesforce.com/docs/platform/salesforce-large-data-volumes-bp/guide/ldv-deployments-infrastructure-skinny-tables.md)**  

-   **[Indexes](https://developer.salesforce.com/docs/platform/salesforce-large-data-volumes-bp/guide/ldv-deployments-infrastructure-indexes.md)**  


    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.

-   **[Divisions](https://developer.salesforce.com/docs/platform/salesforce-large-data-volumes-bp/guide/ldv-deployments-infrastructure-divisions.md)**