Merge Join component sorted outputs [SSIS]
- by jamiet
One question that I have been asked a few times of late in regard to performance tuning SSIS data flows is this:
Why isn’t the Merge Join output sorted (i.e.IsSorted=True)?
This is a fair question. After all both of the Merge Join inputs are sorted, hence why wouldn’t the output be sorted as well? Well here’s a little secret, the Merge Join output…