Eliminate sorts / understand why sorts are occuring

ms_34 2016-08-10 21:33:27

Aaron Bertrand 2016-08-24 03:47:38
Any chance you could upload a non-anonymized, actual, post-execution plan (using an updated version of Plan Explorer)? The current plan has a decent diagram to look at, but no runtime metrics, and the statement has been anonymized to "Statement1" – making it impossible to determine what in the query requires sorts.