Questions tagged [table-spool]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
640 views

Adding 'top 20' massively slows down query!

I have a query: select * from Aview where field=20 order by id desc This returns 2700 rows from the view in about 1 second. Adding 'top 20' to the query makes MSSQL return in 43 seconds!! This has ...
Traderhut Games's user avatar
0 votes
1 answer
1k views

Unpredictable Slowness and Table Spool(Lazy Read)

I was testing on Stackoverflow database to find out possible cases wherein SQL Server doesn't recommend index in the execution plan however if we introduce one, it would help in great way! Did it ...
Learning_DBAdmin's user avatar