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.
And returning 69494 rows.
Just wanted to know how does it work and how is it possible?