Looking at the execution plan I do notice a lot of sorts and spills to tempdb. I am lost in the plan itself and don't know how to fix this. I can provide more details if needed.
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 x691
plan explorer upload x502
poor performance x116
performance tuning x19
asked: Aug 15, 2017 at 03:53 AM
Seen: 66 times
Last Updated: Aug 15, 2017 at 03:53 AM
I need help to improve the performance of this view
May I know is there any recommendation to improve this query performance?
Two Servers. Two radically different plans.
Why does a query inside a IF EXISTS statement not perform the same as outside
New to Query Tuning
I would like to reduce the access to these tables: fact_input_output, dim_org_v, rap_combo
How can I further optimise this query?
SQL Sentry Plan Explorer - SQL Execution varies from 8 seconds to 20 Minutes Because of Where Clause
Index Seek but high cost
Any ideas to increase performance of this query?
© 2013 SQL Sentry, Inc. All rights reserved.