cancel
Showing results for 
Search instead for 
Did you mean: 

Join Performance Better Unsorted?

kmiesse
Contributor

Through previous experience I learned it was more efficient to sort ascending the input streams going into a Join and set the Sorted property on the Join snap to Ascending. But when trying this again in a new pipeline, it executes faster with the Join set to Unsorted. I never waited long enough with it set to Ascending to see if it would finish. How can this be? I left the streams sorted going into the Join.

0 REPLIES 0