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.