Exam OmniStudio-Consultant Topic 2 Question 205 Discussion

Sorting by a formula field can be expensive because formula values are calculated rather than stored like normal indexed fields. If the formula is not indexed, Salesforce may need to calculate values across many candidate records before sorting or filtering them, increasing query processing time. The issue is not primarily JSON parsing memory, session CPU from OmniStudio itself, or cache bypassing. The database query plan is the real bottleneck. Salesforce large-data-volume guidance is clear that selective filters and usable indexes are central to query performance, and Salesforce notes that only certain deterministic formula fields can be custom-indexed. Therefore, sorting/filtering on non-indexed calculated values is a poor performance design for high-volume Data Mapper operations.