Skip to main content Skip to Ask Learn chat experience

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English

Note

Access to this page requires authorization. You can try signing in or changing directories.

Access to this page requires authorization. You can try changing directories.

In this article

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)


Additional resources


  • Last updated on 2012-10-04

In this article

en-us
Your Privacy Choices
  • AI Disclaimer
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Consumer Health Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2026