Spool Operators: Eager Spool, Lazy Spool, Row Count Spool There are a lot of operators in the query execution plan that we generally overlook (I do this for those operators which I have no clue about). Sometimes these operators prove out to be pivotal in the performance of the query and we are forced to take good care of them….
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help