Spool Showplan Operator

The Spool operator saves an intermediate query result to the tempdb database.

Spool operator iconGraphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Reference

Table Spool Showplan Operator
Nonclustered Index Spool Showplan Operator
Eager Spool Showplan Operator
Lazy Spool Showplan Operator
Row Count Spool Showplan Operator

Concepts

Logical and Physical Operators Reference
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance