Not / or should be avoided leads to longer runtime.

Hi, I followed my ACR-recommendations and implemented this rule. As a result, my Microflow ran for 8032ms instead of 6694ms (APD recored this times). Is there a rule of thumb, when I should follow this rule and when not?    Before:     After       Thank you!
1 answers

Hi Tjark,

I would be suprised if anyone could provide a one-size-fits-all rule of thumb for this. It depends on soo many factors: the size of the datasets, the diversity of the datasets, the amount of joins, the amount of available server memory etc.

It is possbile to reason on this a little bit, see also: 

But in the end testing out different variations is the proof of the pudding to me.

I hope this helps.