Cache Showplan Operator

Cache is a specialized version of the Spool operator. It stores only one row of data. Cache is a logical operator. Cache is not used in SQL Server 2005.

See Also

Tasks

How to: Display an Actual Execution Plan

Reference

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