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?
By Wilfried 1 asked Oct 23, 2017 at 07:36 PM