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 x641
plan explorer upload x455
table scan x8
asked: Mar 16 at 06:41 PM
Seen: 62 times
Last Updated: Mar 16 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
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?
how do I bring up the histogram statistics
© 2013 SQL Sentry, Inc. All rights reserved.