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!
Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.
Answers and Comments
query plan x683
plan explorer upload x494
asked: Nov 12, 2015 at 02:09 PM
Seen: 170 times
Last Updated: Nov 18, 2015 at 08:25 PM
Improve query performance
Execution plan mystery
How can eliminate these two sort that are very expensive ? and reduce cost on index seek
No perceived improvement even after adding index
Hi, I am in need of help tuning the following section of the query, pasted below.
Concered with the Est Rows vs Actual Row Count
What would be the best way to avoid Sort operator
Why does the sort input/output 105 actual rows, but only estimate 1 output row?
Eliminate sorts / understand why sorts are occuring
Slow Query Hash Match
© 2013 SQL Sentry, Inc. All rights reserved.