Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting rid of Eager Spool

Status
Not open for further replies.
TomSark

TomSark

MIS
Oct 19, 2000
448
US
Hi All,

Does anyone know how to get rid of an Eager spool in a query plan?

I've got an INSERT SELECT and SQL Server has determined to spool the clustered index on the inserted table to tempdb (using the eager spool step). This is slowing the query way down. I don't want to drop the index because the table has lots of data in it. Also, using other hints doesn't work as well because the clustered index is being spooled regardless of the hint being employed.

Any ideas???

Thanks
Tom Davis
tdavis@sark.com
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Converting or getting rid of decimal places 1
Replies
5
Views
444
Andrzejek
Andrzejek
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
574
grnzbra
grnzbra
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
888
BobSuruncle
BobSuruncle
Cpreston
  • Locked
  • Question
How to get rid of { fn } in my View code
Replies
5
Views
391
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top