---
schema_version: "1"
id: f5f80c888f9ef192c26cab71aa1ec69e7b19402357598f3b99bb6e7d55f41092
title: Improve Query Performance on Materialized DMOs with Secondary Indexes
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/release-notes/262-0-0/rn_cdp_2026_summer_secondary_indexes_materialized_dmos.md
canonical_url: https://help.salesforce.com/s/articleView?id=release-notes.rn_cdp_2026_summer_secondary_indexes_materialized_dmos.htm&release=262.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: aded502921f3e593f8b0e266f3b4bdc6dbf7e7f93e2927fe8f029eb0c61d144d
description: Create secondary indexes on materialized Data Model Objects (DMOs) to significantly improve query performance and reduce credit usage when filtering or joining on non-primary key fields. Previously, secondary indexes were only available for Data Lake Objects (DLOs). Now you can create secondary indexes on materialized DMOs (Derived, Bridge, or Transform types). This improvement is especially valuable for queries on customer segments, aggregated metrics, or large DMOs with fields containing distinct values like customer IDs, email addresses, or zip codes.
products:
  - Cross Cloud
release: "262"
---
# Improve Query Performance on Materialized DMOs with Secondary Indexes

Create secondary indexes on materialized Data Model Objects (DMOs) to significantly improve query performance and reduce credit usage when filtering or joining on non-primary key fields. Previously, secondary indexes were only available for Data Lake Objects (DLOs). Now you can create secondary indexes on materialized DMOs (Derived, Bridge, or Transform types). This improvement is especially valuable for queries on customer segments, aggregated metrics, or large DMOs with fields containing distinct values like customer IDs, email addresses, or zip codes.

**Where:** This change applies to Data 360 in the Developer, Enterprise, Performance, and Unlimited editions.

**When:** This change is available starting in May 2026.

**How:** To create a secondary index, navigate to Data 360 and select Secondary Indexes.