Can you try to use option (maxdop 1) at the end of the query and then check the performance.
The maxdop in the select operator is 24 and that looks a bit odd
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 x664
plan explorer upload x474
i have index seek but with high cost x1
asked: Sep 25, 2017 at 07:58 PM
Seen: 36 times
Last Updated: Sep 26, 2017 at 11:12 AM
This query is very slow. I am new to spatial indexes and am not sure where to begin tuning this query.
How can I avoid this bad plan
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?
How to improve performance
How to get rid of Hash Join and Sort
Help Optimizing View
Estimated way too less compared to Actual no of rows
© 2013 SQL Sentry, Inc. All rights reserved.