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 x673
plan explorer upload x484
table scan x9
asked: Oct 04, 2017 at 05:39 PM
Seen: 37 times
Last Updated: Oct 04, 2017 at 05:39 PM
does it require frequent statistics update or refactor the query isself avoid Estimate/Actual row descrepency and 3 table scans?
Additional Tuning Opportunities
Extrem slow INSERT without reason
Insert into clustered index taking too long
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
© 2013 SQL Sentry, Inc. All rights reserved.