I have a hypothetical scenraio where, if i have a hundred different inputs for a Union:
Would it be better to connect them all to a single Union tool?
OR
Would it be better to connect bunches of 10 to one Union tool, and then connect these 10 Unions to one final Union.
My question is from performance perspective, with reference to a post on the community where it was mentioned that it is better to have multiple Filter tools in succession rather than have one Filter tool with multiple clauses.
I never tried it however I do not think that there will be any difference, as all the data is there in the WF.
Formula tool works differently. Union only union the data together.