Forum Discussion

kmiesse's avatar
kmiesse
Contributor
8 years ago

Join Performance Better Unsorted?

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.

No RepliesBe the first to reply