Questions tagged [index-spool]

The index spool execution plan operator optimizes access to an intermediate result set by building a temporary nonclustered index in tempdb.

Filter by
Sorted by
Tagged with
-1 votes
1 answer

Index Update with Eager Spool and Sort operators in Execution Plan

After an UPDATE statement on a large table, the execution plan shows updates of indexes (all non-clustered) that include the updated columns. Before each index update, there is an Eager Spool ...
Yevgeni Grinberg's user avatar
3 votes
1 answer

Speed Up Cross Apply Without Index Hint

I have a very small table with 12 rows in it that can be created with the following statement: CREATE TABLE dbo.SmallTable(ScoreMonth tinyint NOT NULL PRIMARY KEY, ...
philomathic_life's user avatar
0 votes
1 answer

Plan changes to include Eager Spool causes the query to run slower

We have a reporting query which is erratic in terms of execution plan and run duration. It is either 5 seconds or as slow as 5 minutes. The query is a Select statement with no DML involved. One thing ...
Stackoverflowuser's user avatar
0 votes
1 answer

New Analyst SQL Optimization - Multiple Spools

Unfortunately my ability to Query has outgrown my knowledge of SQL Optimization, so i am hoping someone would help a young analyst by looking at this atrocious execution plan and provide some wisdom ...
user147950's user avatar
24 votes
1 answer

Why doesn't this query use an index spool?

I'm asking this question in order to better understand the optimizer's behavior and to understand the limits around index spools. Suppose that I put integers from 1 to 10000 into a heap: CREATE TABLE ...
Joe Obbish's user avatar
  • 32.1k
1 vote
1 answer

Eager spool for update and delete on partitioned table

When I update or delete on partition table it shows eager spool in execution plan. Image for Update query execution plan showing eager spool:- I can’t understand why it is doing eager spool only ...
Puneet Pathak's user avatar
16 votes
1 answer

Forcing an index spool

I know its something that should be avoided for performance reasons, but am trying to show a condition where it appears as a demo on how to make sure it does not appear. However, I end up with a ...
Akash's user avatar
  • 1,032