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 2008.