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
table scan x9
asked: Oct 04, 2017 at 05:39 PM
Seen: 21 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
Why nested loop instead of more efficient merge join?
query is very slow
SQL Sentry Plan Explorer - SQL Execution varies from 8 seconds to 20 Minutes Because of Where Clause
Sudden slowdown of inline code on 2014, fast with old CE, but can't change.
This query is very slow. I am new to spatial indexes and am not sure where to begin tuning this query.
© 2013 SQL Sentry, Inc. All rights reserved.