Mvc on aggregated Columns

Database

Mvc on aggregated Columns

Hello,

On Td 14.0  , is it recommended to add Mvc on columns which we use for aggregations?

For example if our fact table which has 5-6 B rows  , has a column QTY  and the we use this column in sum() , would be better to leave it without MVC or not.

Thank you.

1 REPLY

Re: Mvc on aggregated Columns

After some tests , the cpu decreased by 15%  on join indexes cases and it remains almost the same or less

on direct agregations.

Any thoughts? Has anyone make similar tests?