How can i faster reduce the amopunt of Data to spped up the query?

avatar image By Tokka 0 asked Oct 14, 2014 at 03:08 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

1 answer: sort voted first

What is Table5 here? Is the Join condition good? looks like it is returning some kind of Cartesian product. For example, it is returning consistently 1429 rows per iteration (versus estimated 1 row) whether it is 3 iteration or 5294 iterations. If we look at the execution plan by estimated costs, they all look like table variables? Or it could be a case of parameter sniffing and needs OPTION (RECOMPILE).

If we had the actual plan instead of the anonymized plan, we could tell better.

avatar image By Sujai Karnam 48 answered Oct 17, 2014 at 09:22 PM
more ▼
(comments are locked)
10|10000 characters needed characters left
Your answer
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:

x641
x166
x117
x109

asked: Oct 14, 2014 at 03:08 PM

Seen: 623 times

Last Updated: Oct 17, 2014 at 09:22 PM