3

I was trying to optimize a query and found that the plan had table spool(eager) in it. But when I ran it on another server which had much more memory(256GB compared to 64GB) than the other one the operator was gone and the query was much faster.

So I am wondering if that memory is even the cause of the plan change which I see ie is it even a plausible theory?

volume of Data is the same.

1
  • 3
    Yes, quite possible, memory does affect the plans. Adding the plan and the query will help you get better answer
    – Shanky
    Nov 14 '16 at 7:43
-2

SQL Server needs to have a reasonably correct estimate of how many rows your query is going to handle. If it doesn’t, things can go terribly, terribly wrong.

MOre info

https://www.brentozar.com/archive/2013/08/query-plans-what-happens-when-row-estimates-get-high/

Not the answer you're looking for? Browse other questions tagged or ask your own question.