SentryOne Team Blog (blogs.sentryone.com)

Tag : merge join

Paul White : Avoiding Sorts with Merge Join Concatenation

Paul White (@SQL_Kiwi) talks about coercing the optimizer into avoiding sorts, reminding us that sound indexing should still be our first line of attack.