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.
================
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit