does it require frequent statistics update or refactor the query isself avoid Estimate/Actual row descrepency and 3 table scans?
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 x670
plan explorer upload x480
table scan x9
asked: Mar 16, 2017 at 06:41 PM
Seen: 70 times
Last Updated: Mar 16, 2017 at 06:41 PM
Tbl_Hurdle_Test Only has 25 000 rows why in the actual plan does the Table contain over 400 mil rows
Function call as INNER JOIN causes slow RID lookup
Statistics On Temporary Tables
Additional Tuning Opportunities
Slow Query - Incorrect Estimated Executions?
why query slow?
Query plan shows index seek on table not referenced in the query anywhere
Are the inserts really what is causing this query to go slow?
Appropriate statistics or indexes for this plan?
© 2013 SQL Sentry, Inc. All rights reserved.