What is Table Spool

microsoft.public.sqlserver.programming

24 Nov 2005 4:40 PM

Roy Goldhammer

Hello there

On the execution plan i see some times Table Spool

What that meens, and is there a way to reduce its action?

--
øåòé âåìãäîø
òúéã äðãñú úåëðä
èì' 03-5611606
ôìà' 050-7709399
àéîééì: r**@atidsm.co.il

24 Nov 2005 6:10 PM

Andrew J. Kelly

Have a look in BooksOnLine under "Table Spool operator" for a description.

--
Andrew J. Kelly SQL MVP

Show quote

"Roy Goldhammer" <r**@hotmail.com> wrote in message
news:%237gtnUR8FHA.2040@TK2MSFTNGP14.phx.gbl...
> Hello there
>
> On the execution plan i see some times Table Spool
>
> What that meens, and is there a way to reduce its action?
>
> --
> øåòé âåìãäîø
> òúéã äðãñú úåëðä
> èì' 03-5611606
> ôìà' 050-7709399
> àéîééì: r**@atidsm.co.il
>