I was optimizing one of the Stored Procedure for which I went through the execution plan of it.

In the execution plan I see the operator Index Spool (Eager Spool).

There I see it is taking 1759 rows as input.

enter image description here

And returning 69494 rows.

enter image description here

Just wanted to know how does it work and how is it possible?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.