Specify Spool?

[jazerr]

I have a question regarding Table Spools.

I have a query that inserts data from a table into a table variable. On the insert, the execution plan says that 79% of my time is being spent on the Table Spool/Eager Spool.

Given that the insert is taking like 8 minutes, I would like to cut this part out. Is that possible? BOL says its doing this for the purposes of rewinds, and I dont need that.

Is there a way to specify no spool, or to reduce the amount of time spent on this step?

 

[JayKusch]

How many records are you loading into the table var?

Thanks

J. Kusch

 

[jazerr]

It will vary. Sometimes as many as 1000, but usually only around 50.