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.

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

1 Answer 1


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


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