We have a table with quite some expression fields, that normally do not give a lot of performance loss because they are usually always shown as a detail of an order.
However, we've created a variant on this table that breaks with this and although I've hidden the majority of the fields, the select that is generated in the end product will still contain all these expression fields that really make things slow. Wouldn't it be a nice idea to not add expression fields to the select of a variant when they are hidden?
I know I can make a seperate view, but I would like to not do that. It would be great if the selects for view/tables (based on variants) could only contain the data-elements that will be shown (non-hidden).