A report's filter criteria is basically just a query, in metadata form. In fact, you can extract report filters as metadata through the API. But whether you look at it through the front end / UI or the metadata / API, it's just a series of predicates.
Does Salesforce evaluate these predicates in the order they're entered when the report is built, or does it optimize the order they execute "on the fly" when the report is run, or does it have an order built in that it runs them? Or last option, is it just parkour - there isn't a discernable order it's firing them?
I ask because the order in which Salesforce's reporting engine executes these predicates definitely affects runtime depending on how many records you have and what filtering you're using.
3 respuestas
Manoj Nambirajan (Dell Technologies) Forum Ambassador
To my understanding it will go in the order you define in the Filter Logic you have defined.. If no filter logic.. then it will take one line after the other.
In case you have slowness in report performance due to growth of data.. have you tried skinny table implementation? Thats one way to improve performance.