TD Join Indexes


TD Join Indexes


Concerning the creation of Join Indexes and Mvc passed or not  , after tests i conclude it is better not to have Mvc on calculated columns(20% less) but should i have MVC on all attributes (even from small tables , does this influence the cpu... , on plan it allows the compressed values , but always the last step is cpu consuming - the aggregation -  , should it help to add MVC on attrubutes there , due to the Spool  -it goes up to 6 TB -.

Furthermore , is it better to create the indexes during the creation of the join index or after ?

Thank you.