Spool Operators: Index spool and Window spool

Spool Operators: Index spool and Window spool In my previous article I talked about a few spool operators (Eager Spool, Lazy Spool and Rowcount Spool), now it’s time to talk about the remaining spool operators that the query optimizer uses to make our queries run faster. In this article I will talk about the Non Clustered Index Spool. Then I…