Home > Archive > Microsoft SQL Server forum > February 2006 > Table spool/Lazy spool question









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Table spool/Lazy spool question
Robert

2006-02-20, 8:24 pm

Greetings,

In Google I am finding what the deffinition of a table spool operator is
but not what it is doing to performance. The execution plan shows the
output of a clustered Index scan (54 records) going into the Table Spool
operator and having a output of 218,000 records out. Where do the 218,000
records come from??


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com