Control (or indirectly manipulate) the estimates of a hash join

For the first (reading right to left) hash join on the top branch, how can i manipulate the estimates? The nodes to the right of it are really close and this one just isn't and i feel if this one was more accurate the operators for other parts of the plan would change and perhaps positively influence overall performance.

(edit) Interesting is that if i add OPTION(HASH JOIN), the statement completes in 20 seconds. That seems to validate my supposition that if the estimates were more accurate the optimizer wouldn't choose the NL joins which is what i was guessing was killing the performance.

Plan.pesession (26.6 kB)
avatar image By Dan Holmes 725 asked Jun 20, 2014 at 03:13 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

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.

Follow this question

Topics:

x631
x166
x26

asked: Jun 20, 2014 at 03:13 PM

Seen: 441 times

Last Updated: Jun 20, 2014 at 03:21 PM