does it require frequent statistics update or refactor the query isself avoid Estimate/Actual row descrepency and 3 table scans?

does it require frequent statistics update or refactor the query isself avoid Estimate/Actual row descrepency and 3 table scans?

phs.pesession (16.7 kB)
avatar image By George Zhou 1 asked Mar 16, 2017 at 06:41 PM
more ▼
(comments are locked)
10|10000 characters needed characters left
▼ Viewable by all users
0
0 answers: sort voted first ▼
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

We are Moving!

<p><br></p>

Follow this question

Topics:

x691
x502
x24
x9

asked: Mar 16, 2017 at 06:41 PM

Seen: 87 times

Last Updated: Mar 16, 2017 at 06:41 PM

Related Questions

Statistics problem?

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?