How to get rid of Hash Join and Sort

ManojG 2015-11-12 14:09:56

Aaron Bertrand 2015-11-18 20:25:14
Hi Manoj, can you please update Plan Explorer to the latest build (Help -> Check for Updates), and then generate an execution plan for this query inside of Plan Explorer using the Get Actual Plan button on the toolbar? Opening a plan generated from Management Studio is less useful because it is missing many of the runtimes metrics and other data that Plan Explorer collects but SSMS does not. Thanks!