Aggregate Optimizer
Question
Platform Version
11.15.0 (Build 35089)

I have this action with no output. The aggregate gets 1 record from the 'Project' table which has 9 columns, and assigns two of these columns to two local variables. Will the platform optmize the query and only fetch the two columns i'm assigning to the variables or will all of the 9 columns be fetched? 


HI Flavio,

It would fetch all the 9 columns as you have isolated the aggregate in a  server action . Please check below link

https://success.outsystems.com/Documentation/Best_Practices/Performance_and_Monitoring/Performance_Best_Practices_-_Queries

Check  Avoid using isolated aggregates

Best Regards

Devendra

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.