Sort or No sort before merge join depending on order columns in join condition

Both table PODRIA_Complete and PODRIA_Intermediate have a primary key on columns MC_Market_Code, Account, Product, Audit_Date, Activity. Column in the order as mentioned. MC_Market_Code is in both large tables (~ 500 million rows) the partition key. When joining both tables on the PK columns, the order of columns mentioned in join condition do determine if sort is needed (unwanted) or not. Is this expected behaviour of SQL Server?

Plan.pesession (25.2 kB)
avatar image By Wilfried 1 asked Oct 23, 2017 at 07:36 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

We are Moving!


Follow this question



asked: Oct 23, 2017 at 07:36 PM

Seen: 45 times

Last Updated: Oct 23, 2017 at 07:36 PM