How to get rid of Hash Join and Sort

avatar image By ManojG 1 asked Nov 12, 2015 at 02:09 PM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ Nov 18, 2015 at 08:25 PM

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!

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.

Follow this question

Topics:

x683
x494
x25
x5

asked: Nov 12, 2015 at 02:09 PM

Seen: 170 times

Last Updated: Nov 18, 2015 at 08:25 PM